Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to generate a formula that will give me a count of all inventory owners that have a TotalCurrentInventory that is greater than their AllocationMax, for a given AllocationGroup.
First I need to calculate, if TotalCurrentInventory > AllocationMax for each Inventory Owner at a given AllocationGroup. Then I need a total count of all the InventoryOwners above their maximum broken out by AllocationGroup.
I have tried the equation below, but it seems to give me a total count of all InventoryOwners, instead of just the InventoryOwners with TotalCurrentInventory > AllocationMax.
Count({<AllocationGroup = {"(TotalCurrentInventory > AllocationMax)"}>} Distinct InventoryOwner)
Has anyone found a solution for comparing set analysis where the value of one field is greater than another field?
Try this:
=Count(distinct if(TotalCurrentInventory >AllocationMax,InventoryOwner))
Try this:
=Count(distinct if(TotalCurrentInventory >AllocationMax,InventoryOwner))
Hi ,
in which object you are wring this Set Analysis?(Text Box,Charts..etc) it will also important while writing Set Analysis.
as per my understanding you are trying in a Pivot Table
=if( TotalCurrentInventory > AllocationMax,count(Distinct InventoryOwner))
correct me if my assumption is wrong.
Hello,
Were you able to do this with Set Analysis?