Skip to content
Gallery
dummy tracker
sample
Female shorts form
Sample teams
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
Tampa Bay Brigade
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
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
​
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
Tampa Bay Brigade
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
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
⁠
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.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.