topic Re: Color logic in pivot table not working in App Development

Color logic in pivot table not working

kavita25 — Sat, 16 Nov 2024 18:10:19 GMT

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

Re: Color logic in pivot table not working

sunny_talwar — Mon, 31 Aug 2020 12:31:24 GMT

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())

Re: Color logic in pivot table not working

kavita25 — Tue, 01 Sep 2020 11:12:40 GMT

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

Thanks..for your help 🙂

Regards,

Kavita