How to calculate distinct values ?

Options
Akshay07
Akshay07 Member, ALL USERS, Partner Posts: 5 Contributor
in Planning & Modeling

Hi All,

I have a list which has Product as parent and SKU as list. I am trying to calculate the number of SKUs with demand > 0 for all periods. Right now, using this formula - If demand > 1 then 1 else 0. The issue with this formula is that the summary adds individual SKUs with demand at yearly level. See below screenshot -

Product 1 has only one sku which has demand in all the years.

 F21F22F23F24F25All Periods
Product 1111115

 

Ideally, all periods should give only 1 as the answer as there is only one unique sku under product 1 having demand. Any leads will be appreciated.

 

Thanks in advance.

Tagged:

Comments

  • Akshay07
    Akshay07 Member, ALL USERS, Partner Posts: 5 Contributor

    Hi @AntonMineev - Thank you for your response. I tried using the formula for summary. The problem is, the module is dimensioned by List A (Product as parent and SKU as list) and the line item (to calculate skus with demand) is being applied applied to List B (Only has product and no child). Hence a subsidiary view is created, in this view the summary is getting calculated correctly but in the main module it does not. Is there any other solution to calculate ?

Categories