Color logic in pivot table not working

[kavita25]

Hello Everyone,

I want to color the column if my Actual is equal and greater than the Forecast in pivot table.

As shown in the below screenshot, on click of Jan-2020 its working for some category and for some category its not working. For e.g.  Adj EBITA Actuals and Forecast is same, then too its not showing in green.

Color logic: =if(aggr(sum(forecast_bmc), category,period)=aggr(sum(actual_bmc), category,period),Green()).

Please look into the issue.

@sunny_talwar @Gysbert_Wassenaar 

Thanks & Regards,

Kavita

[sunny_talwar · Accepted solution]

Equal seems to be related to rounding issue and greater, you just didn't use  greater or less sign... try this

=If(Round(Sum(forecast_bmc), 0.00001) <= Round(Sum(actual_bmc), 0.00001), Green())

[kavita25]

Thank You so much.. It worked. I was trying with num and not round function.

Thanks..for your help 🙂

Regards,

Kavita