Forum Discussion
Hinnantj
2 years agoFrequent Visitor
Running Balance - Reset to Zero
Hi! I am trying to get a running/remaing balance for each date based on the item, taking into account the monthly reduction and production. In cases where the balance is below zero, I only want to di...
Hinnantj
2 years agoFrequent Visitor
Hello! Unfortunately, the results are not as expected. The balance is not reseting to zero upon after going negative. An updated sample data file can be found here SampleDate_Revised
If you upload and filter on items "B744" and "D127", you will see the Remaining_Balance measure does not reset as expected (shown in "Expected" column).
Hinnantj
2 years agoFrequent Visitor
Anonymous - Hi! Have you had a chance to review latest comments?