Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have an expression that gives me a percentage of Out of Date items. But I want to only perform this calculation if there are more than X number of total items at the site.
As at the moment, I have many sites in my graph showing up as 100% OOD (Out of Date), but all these sites only have one item.
So I want to add in the condition that "if site has 3 or more items, then calculate the percent of items that are out of date".
See current, basic % expression below.
Count(IF("OOD FLag"=1,[OOD FLag])) / count([OOD FLag])
Thanks
Try this
If(count([Item])>=3,Count({< "OOD Flag"=1 >} [Item]) / Count([Item]))