Forum Discussion

Eric's avatar
Eric
Advocate I
7 years ago

Transaction Level Running Total

I am trying to calculate running balances at a transaction level for inventory.  The measures are working on a daily level but I cannot get the "Qty Before" balances to calculate correctly at a trans...
Need Help
  • Eric's avatar
    Eric
    Advocate I
    7 years ago

    Greg, thanks for the response.  I haven’t tried the CALCULATETABLE function, I will give that some thought.  But, anytime we try to use SUMX(FILTER( we run out of memory even with a table that only has 2 million records.

     

    Thanks,

     

    Eric