Forum Discussion

lreinhard77's avatar
lreinhard77
Frequent Visitor
3 years ago

Calculation inventory values

Hi,  I want to calculate inventory values as exemplified in the following screenprint.  My problem is related to the issue price calculation for which I need the **bleep** value and **bleep** qty f...
calculation
inventory value
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi lreinhard77 ,

Sorry, I'm not smart. Are you trying to calculate the sales pricez column? If according to you 427.5=(0+17100)/40, which column does 40 represent?Cumcurrenh or CurrentBuy?Why is the third column 0?(0-2137.5)/40=53.4375 and how do you get the 55 in (0+17100-2137.5+0+0+0+8100)/55? And why does this result appear in the fourth and fifth row? What is the logic of the calculation?

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

lreinhard77's avatar
lreinhard77
Frequent Visitor
3 years ago

Hi, 

I tried to make things more clear with the following illustrations.

I am not sure if I can attach you my Excel file here. 
Hope those screenprints make things clear.