Forum Discussion

vasathi's avatar
vasathi
Icon for Helper II rankHelper II
4 years ago

Inventory Aging

Dear Friends

 

I'm having an issue with Inventory aging calculations.


i have measure like, the result gives 0 or blank

 


Can some could you help me or find me wher i did wrong...

 

Thanks in advance

2 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User
    4 years ago

    vasathi 

    Not sure how your data model is setup and the measure is executed, can you try the following measure? Replace the line inside your Filter function here

    Age 60-90 (qTY) = 

sumx ( 
    FILTER ( .... ),
    [Total Qtr]
)

     

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi vasathi ,

    Not certain what is your sample table look like, basically the measure could return the calculated value.

    In addition, how did you write [Total Qty] measure? Perhaps you can share more details about this issue or just modify the table structure based on the test sample.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.