This content has been marked as final.
Show 4 replies

1. Re: which type of join should I use to get the correct calculations from this table and filtering?
Deepak Rai Sep 19, 2018 4:09 PM (in response to a m)Hi a m
You are doing it Right. Just use this calculation when you want to Sum per month strore transit
ACTUAL SUM
{FIXED month,place,transit:AVG(actual)}
FORECAST SUM
{FIXED month,place,transit:AVG(forecast)}

2. Re: which type of join should I use to get the correct calculations from this table and filtering?
Deepak Rai Sep 19, 2018 4:13 PM (in response to a m)
SUM.twbx 11.3 KB


3. Re: which type of join should I use to get the correct calculations from this table and filtering?
a m Sep 20, 2018 12:25 PM (in response to Deepak Rai)thanks so much for the help Deepak
I have another question for you. I don't know if I should make another topic for it but here goes
what formula can be used to make a calculated field for the variance of the total of ACTUAL SUM and FORECAST SUM for each month?
I tried ATTR([Actual sum])  [HR Total] but that only works for each transit but it does not work when it's the totals of the month.
thanks