Expression not working

[suvechha_b]

Hi All ,

Please help me to get the expression correctly for "Days Cover per FC".

When , I am selecting specific product the "Days Cover per FC" is pulling correctly but if I don't select any product the value is wrong .

Sample model attached.

[Marcio_Campestrini · Accepted solution]

Hi

As you're using TOTAL in your expression, the "Days Cover per FC" will change according your selection.

Why are you using it?

[Anil_Babu_Samineni]

Does it possible to share the expression, I don't have license software by hand

[Anonymous]

Hi, try this expression:

Sum(Aggr((sum(stock_on_hand)/(SUM( {<  period_key = {"<=$(vPrevPeriod1)>=$(vPrevPeriod6)"} >}sales_plan) /6))*(22),[Product Code]))

This is the output:

Regards!!