Hi friends,
Below is my requirement and I am unable to implement the proper solution for this requirement.
I have Proposed (yellow)and Revised budget(green).If revised budget is zero I have to take Proposed Budget.If Revised is not zero I have to show revised budget.Based on below example my bar has to show Proposed-0,and revised(stacked bar with 40000(yellow) and 8000(green).
For example:
Proposed Budget for May Revised Budget for May
10000 8000
20000 0.00
20000 0.00
Proposed Budget for June Revised Budget for June ( In this case Proposed-0 and Revised is 60000 with yellow color)
20000 0.00
20000 0.00
20000 0.00
Below is my expression.
For Proposed Budget:
if(REVISED_BUDGET=0,IF([UNABLE_TO_SPEND]='NO',0,SUM(AGGR(SUM(distinct{<SUB_PROJECT-={'-'}>}[PROPOSED_BUDGET]),YEAR,type,SUB_PROJECT))),0)
For Revised Budget:
if(REVISED_BUDGET=0,IF([UNABLE_TO_SPEND]='NO',0,
SUM(AGGR(SUM(distinct{[SUB_PROJECT]-={'-'},[REVISED_BUDGET]-={'0.00'}>}[REVISED_BUDGET]),YEAR,type,SUB_PROJECT,MAIN_PROJECT))),
SUM(AGGR(SUM(distinct{<[SUB_PROJECT]-={'-'},[REVISED_BUDGET]={'0.00'}>}[PROPOSED_BUDGET]),YEAR,type,SUB_PROJECT,MAIN_PROJECT)))
+
SUM(AGGR(SUM(distinct{<[SUB_PROJECT]-={'-'},[REVISED_BUDGET]-={'0.00'}>}[REVISED_BUDGET]),YEAR,type,SUB_PROJECT,MAIN_PROJECT))
Please help on this.
