Skip to content
sample
Master Team $
Name
Player Fees
Orders Revenue
Player Fees paid
Player Fees Due
Due to players
Name
Player Fees
Orders Revenue
Player Fees paid
Player Fees Due
Due to players
Palm Beach Breakers
5,000
$6,000.00
$500.00
-$1,500.00
-$1,000.00
Fort Lauderdale Lions
4,569
$3,500.00
$500.00
$569.00
$0.00
South Beach Palms
2,400
$2,000.00
$500.00
-$100.00
$0.00
Daytona Venom
4,399
$6,000.00
$500.00
-$2,101.00
-$1,601.00
Tampa Bay Brigade
4,339
$3,500.00
$500.00
$339.00
$0.00
Orlando Aces
3,459
$5,000.00
$500.00
-$2,041.00
-$1,541.00
SWFL Sharks
4,456
$5,000.00
$500.00
-$1,044.00
-$544.00
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
Do I understand correctly that the Player Fees Due has the correct numbers, but you only want to show the negative numbers?
@Ruby George
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
Name
Player Fees
Orders Revenue
Player Fees paid
Player Fees Due
Due to players
Palm Beach Breakers
5,000
$6,000.00
$500.00
-$1,500.00
-$1,000.00
Fort Lauderdale Lions
4,569
$3,500.00
$500.00
$569.00
South Beach Palms
2,400
$2,000.00
$500.00
-$100.00
Daytona Venom
4,399
$6,000.00
$500.00
-$2,101.00
-$1,601.00
Tampa Bay Brigade
4,339
$3,500.00
$500.00
$339.00
Orlando Aces
3,459
$5,000.00
$500.00
-$2,041.00
-$1,541.00
SWFL Sharks
4,456
$5,000.00
$500.00
-$1,044.00
-$544.00
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
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
@Ruby George
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.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.