Exclude member from Dynamic Calc
I am working on a Business rule. The Business wants to calculate "ABC%" from YTD numbers. But YTD is set as dynamic calc. So my BR is calculating "ABC%" by month and adding them up for YTD.
e:g.
Jan_YTD | Feb_YTD | Mar_YTD | |
Account- ABC | 200 | 400 | 600 |
Account- DEF | 100 | 200 | 300 |
EXPECTED- ABC% | 0.5 | 0.5 | 0.5 |
Current- ABC% | 0.5 | 1 | 1.5 |
Any Suggestions?
Tagged:
1