Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that shows a monthly accuracy %.
Dimension: =if(today()>FISCAL_YEAR_MONTH,FISCAL_YEAR_MONTH)
Expression: $(vForecastVariance) = num((($(vForecastRound)-$(vActualRound))/($(vForecastRound))), '#,##0.0%')
Variable: vActualRound = round(sum({$}ACT_AMT), 1000)/1000
I only want the data to show where sum($(vActualRound)))>0 so that if we don't have actuals posted for the current month, no % will show for that month.
My expression is set to show condtional: aggr(sum($(vActualRound)))>0, FISCAL_MONTH_YEAR) but this doesn't seem to be working because even though we don't have anything in ACT_AMT for November, I still see a % for November.
Any thoughts?
Thanks,
Cassandra
You can write Calculated Dimension like below:
IF(AGGR( Sum(ACT_AMT) , FISCAL_YEAR_MONTH )>0,FISCAL_YEAR_MONTH)
Or change Your expression:
IF( $(vActualRound) > 0 , num((($(vForecastRound)-$(vActualRound))/($(vForecastRound))), '#,##0.0%') )
You can write Calculated Dimension like below:
IF(AGGR( Sum(ACT_AMT) , FISCAL_YEAR_MONTH )>0,FISCAL_YEAR_MONTH)
Or change Your expression:
IF( $(vActualRound) > 0 , num((($(vForecastRound)-$(vActualRound))/($(vForecastRound))), '#,##0.0%') )