Forum Discussion

EnderWiggin's avatar
EnderWiggin
Helper I
5 years ago
Solved

Running total calculation without filter?

Hi All, I created a running total calculation which counts from a start balance. The start balance contains the actual stock quantity, stock input output quantity before the actual month + actual mo...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    OK I think I found it, add "<" to this measure

     

    Looking good!

     

EnderWiggin's avatar
EnderWiggin
Helper I
5 years ago

Hey aj1973,

Ok,  I changed the type of the 0BeforeActualYearMonth from text to number and modified the related measures according to the changes. Here is the result: RunningTotalDemoWithCalendar1_aj1973_3 

I don't see any significant changes in the result. If the running total with start balance works then the 0 column (this was 0BeforeActual value in the previous versions) is not visible. If the 0 column is visible then the running total does not work.

So, back to my original question:

"Is there any way to create running total calculation without filtering the "0BeforeActual"  column?" 

Thank you!

 

 

 

aj1973's avatar
aj1973
Community Champion
5 years ago

OK I think I found it, add "<" to this measure

 

Looking good!

 

  • EnderWiggin's avatar
    EnderWiggin
    Helper I
    5 years ago

    Hey aj1973,

    yes, you did it!! Thank you for your solution and your efforts and patiance during this loong conversation 

     

    Have nice day!

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Indeed,

     

    Welcome