Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to calculate the number of records that either do or do not meet a condition based on an set analysis calculation.
Does anybody know how this is achieved.
Thank you.
Hi @NormanStanleyBadger Can you give more context to your question?
Maybe a sample data and expected output?
Hi @Vishal_Gupta, thank you for your reply.
I have a set analysis that calculates average stock days per month (based on entry & leave date for each SKU)
I also need to calculate the total number of SKUs that fall within an SLA for number of stock days.
I tried the simple approach of adding my set analysis to an if statement but it does not work.
Sum(If( Avg({< Set Analysis >} [Leave Date] - [Entry Date]) <=3,1,0))
@NormanStanleyBadger Not able understand your question without data and expected output.