set analysis script

[#1]

Hi,

I have data that when product is sold, it shows within the Retail Period (Year) for that part.

I want to count the number of Retaill Periods, by part.

At the moment Parts either have a status of Active (Y) or Non-Active (N)

How can I express this so it only counts the Active Parts, when I choose a Year?

({$<Year={$(=Only(Year))},(Active)=>}[Retail Period])

Thanks,

Paul

[MayilVahanan]

Hi

Try like this

({$<Year={$(=Only(Year))}, Active= , Parts = {'Y'}>}[Retail Period])

[jagan]

Hi,

Try like this

=Count({$<Year={$(=Max(Year))}, Parts = {'Y'}>} distinct [Retail Period])

Regards,

Jagan.

[Gysbert_Wassenaar]

Something like this:

count({$<Year={$(=Only(Year))}, PartStatus={'Active (Y)'}>}[Retail Period])

Replace PartStatus with the name of the field that contains the status values for the parts. Replace 'Active (Y)' with the value that indicates active status.