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      
            