1 Reply Latest reply: Dec 2, 2015 4:04 PM by Srikanth P RSS

    Only Show Data for Months with Data

    Cassandra Baqir

      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.

       

      12-2-2015 1-53-09 PM.jpg

       

      Any thoughts?

       

      Thanks,

      Cassandra