Counting expression in pie chart

[JJ141]

Hi,

Hope your day is going well.

I am currently trying to create a pie chart which shows the count of y/n. The y/n column is made from the expression below:

If(
fabs(
([Forecast Status] - (sum([Quantity Delivered_forecast]) / 3))
/
(
([Forecast Status] + (sum([Quantity Delivered_forecast]) / 3)) / 2
)
* 100
) > 20, 'Y', 'N')

Any help would be much appreciated. 🙂

Thanks 

[MayilVahanan · Accepted solution]

Hi @JJ141 

Try like below

Count of "Y":

Sum(If(
fabs(
([Forecast Status] - (sum([Quantity Delivered_forecast]) / 3))
/
(
([Forecast Status] + (sum([Quantity Delivered_forecast]) / 3)) / 2
)
* 100
) > 20, 1))

Count of N:

Sum(If(
fabs(
([Forecast Status] - (sum([Quantity Delivered_forecast]) / 3))
/
(
([Forecast Status] + (sum([Quantity Delivered_forecast]) / 3)) / 2
)
* 100
) <= 20, 1))

Or,

Try to bring the flag in Script

[JJ141]

Thanks @MayilVahanan it worked!

[MayilVahanan]

Hi @JJ141 

If its satisfied your requirement, could you please close this thread