Sum If Based on a Set Analysis Calculation

[NormanStanleyBadger]

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.

[Vishal_Gupta]

Hi @NormanStanleyBadger Can you give more context to your question?

Maybe a sample data and expected output?

[NormanStanleyBadger]

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

[Vishal_Gupta]

@NormanStanleyBadger  Not able understand your question without data and expected output.