Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying with a variable and If statement to render a bubble graph based on selections. I get all to work except the below syntax:
=if($(vSelect)=1,(sum(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))/
(sum(TOTAL(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure))))))),
if($(vSelect)=2,(SUM(IF(Year2Date(PERIOD,0,1,LatestDate),$(vMeasure)))/SUM(TOTAL(IF(Year2Date(PERIOD,0,1,LatestDate),$(vMeasure))))))
What am I missing ?
kindly advise
Regards
Try this
=if($(vSelect)=1,(sum(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))/
(sum(TOTAL(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))))),
if($(vSelect)=2,(SUM(IF(Year2Date(PERIOD,0,1,LatestDate),$(vMeasure)))/SUM(TOTAL(IF(Year2Date(PERIOD,0,1,LatestDate),$(vMeasure)))))))
Nested if should be like this
= If( Condition1, Exp1 , If(Condition1, Exp2, Exp3(default)))
Try this
=if($(vSelect)=1,(sum(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))/
(sum(TOTAL(if(Year2Date(PERIOD,0,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))))),
if($(vSelect)=2,(SUM(IF(Year2Date(PERIOD,0,1,LatestDate),$(vMeasure)))/SUM(TOTAL(IF(Year2Date(PERIOD,0,1,LatestDate),$(vMeasure)))))))
Nested if should be like this
= If( Condition1, Exp1 , If(Condition1, Exp2, Exp3(default)))