Gallery
dummy tracker
Share
Explore

# sample

Master Team \$
Name
Player Fees
Orders Revenue
Player Fees paid
Player Fees Due
Due to players
1
Palm Beach Breakers
5,000
\$6,000.00
\$500.00
-\$1,500.00
-\$1,000.00
2
Fort Lauderdale Lions
4,569
\$3,500.00
\$500.00
\$569.00
\$0.00
3
South Beach Palms
2,400
\$2,000.00
\$500.00
-\$100.00
\$0.00
4
Daytona Venom
4,399
\$6,000.00
\$500.00
-\$2,101.00
-\$1,601.00
5
4,339
\$3,500.00
\$500.00
\$339.00
\$0.00
6
Orlando Aces
3,459
\$5,000.00
\$500.00
-\$2,041.00
-\$1,541.00
7
SWFL Sharks
4,456
\$5,000.00
\$500.00
-\$1,044.00
-\$544.00
8
Atlanta Wild
2,456
\$5,000.00
\$500.00
-\$3,044.00
-\$2,544.00
There are no rows in this table
8
Count
31,078
Sum
\$36,000.00
Sum
\$4,000.00
Sum
-\$7,230.00
Sum
@Ruby George
Do I understand correctly that the Player Fees Due has the correct numbers, but you only want to show the negative numbers?
I am rereading your first posting in the thread and you are talking about column 1, 2 and 3, but in the calculation samples there are only 2 numbers. That makes it kind of hard to understand. ​If I look at the column Due to players, I don’t understand that either. Look at the first line - where does 2361.25 come from?

Fixed Master Team \$ 2
1
Palm Beach Breakers
5,000
\$6,000.00
\$500.00
-\$1,500.00
-\$1,000.00
2
Fort Lauderdale Lions
4,569
\$3,500.00
\$500.00
\$569.00
3
South Beach Palms
2,400
\$2,000.00
\$500.00
-\$100.00
4
Daytona Venom
4,399
\$6,000.00
\$500.00
-\$2,101.00
-\$1,601.00
5
4,339
\$3,500.00
\$500.00
\$339.00
6
Orlando Aces
3,459
\$5,000.00
\$500.00
-\$2,041.00
-\$1,541.00
There are no rows in this table
8
Count
31,078
Sum
\$36,000.00
Sum
\$4,000.00
Sum
-\$7,230.00
Sum
@Ruby George
I am not sure of the calculations you have made, so I will just assume they are correct according to your needs. However, I’ve shown how one column can show only positive values, and another column show only positive ones
The formula used helps reduce calculations as it only needs to calculate once:
Withname( [Player Fees]-[Orders Revenue], Amount If(Amount<0,Amount,'') )
This formula does the maths, and names the result ‘Amount’. Then it checks if ‘Amount’ is less than zero, if so show it, otherwise make it empty.
The advantage of this is that the maths only happens once.