Forum Discussion

Zvekanm's avatar
Zvekanm
Frequent Visitor
3 years ago

Running total

Hi ,       i have small issue with running total.  Im calculating stock value in warehause from 2022 till today, and its working. For quantities vorking with no mistake, but for value not. Pro...
Need Help
eliasayyy's avatar
eliasayyy
Icon for Memorable Member rankMemorable Member
3 years ago

hmm looks complicated try 

CALCULATE(
   [Starting Value]+[Total Value 101]+[Total Value 102]-[Total Value 122]+[Total Value 123]-[Total Value 261]+[Total Value 262]-[Total Value 711]+[Total Value 712]-[Total Value 291]+[Total Value 309]-[Total Value 601]+[Total value 602],
    'DIM Calendar'[Transaction_Date]<=MAX('DIM Calendar'[Transaction_Date]
    )
    )/117.5
Zvekanm's avatar
Zvekanm
Frequent Visitor
3 years ago

eliasayyy 

 

if you have more simple solution... then you are my best friend 😄

problem is that i must track stock value on weekly base of each material.

then material group... procurment type.. supplier..

lot of demands from my manager.

this is only solution that work for me.

plus i need every type of movement in other calculation..