
1. Re: Calculate running percentage on a fixed level
Naveen B Sep 27, 2018 7:16 AM (in response to Sidhanth Sharma)HI Sidanth,
if you are not using SUM around fixed calculation, sum(Fixed calcuation)
you need to maintain the aggregated level then only you will get the required O/P
Hope this helps
Plz mark this answer as correct or helpful to close the thread
BR,
NB

2. Re: Calculate running percentage on a fixed level
Sidhanth Sharma Sep 27, 2018 7:30 AM (in response to Naveen B)RUNNING_SUM(SUM([RTS covered qty])) / {FIXED [CCD Dt Bus Sesn Yr Cd],[Prod Cd]:SUM([RTS qty])}
Can you help me here in this calculation?

3. Re: Calculate running percentage on a fixed level
Michael Hesser Sep 27, 2018 7:32 AM (in response to Sidhanth Sharma)Sidhanth;
Make sure you're using the Tableau Forum Search function. You're likely to quickly find answers to questions just like this.
All the best!

4. Re: Calculate running percentage on a fixed level
Michael Hesser Sep 27, 2018 8:09 AM (in response to Sidhanth Sharma)Divide & conquer has always worked best for me! For this calculation:
RUNNING_SUM(SUM([RTS covered qty])) / {FIXED [CCD Dt Bus Sesn Yr Cd],[Prod Cd]:SUM([RTS qty])}
I'd break it into ~4 parts and make sure all are working properly on your sheet:
SUM_RTS_covered_qty
SUM([RTS covered qty])
RUNNING_SUM_RTS
RUNNING_SUM([SUM_RTS_covered_qty])
FIXED_PORTION
{FIXED [CCD Dt Bus Sesn Yr Cd],[Prod Cd]:[SUM_RTS_covered_qty]}
COMBINED_FORMULA
[RUNNING_SUM_RTS] / [FIXED_PORTION]
By breaking it up, you'll be able to see if there is any part of the (longer) equation that isn't working as expected.
I suspect you may need to add an ATTR, changing your calc to:
RUNNING_SUM(SUM([RTS covered qty])) / ATTR( {FIXED [CCD Dt Bus Sesn Yr Cd],[Prod Cd]:SUM([RTS qty])} )

5. Re: Calculate running percentage on a fixed level
Naveen B Sep 27, 2018 10:39 AM (in response to Sidhanth Sharma)RUNNING_SUM(SUM([RTS covered qty])) / SUM({FIXED [CCD Dt Bus Sesn Yr Cd],[Prod Cd]:SUM([RTS qty])})
above cal will do