Forum Discussion

JoeKulasa's avatar
JoeKulasa
Regular Visitor
5 years ago

Running total not calculating correctly

I have a the following measure:     The measure is calculating a running total of another calculated column:     Problem:   The measure is calculating correctly on some lines, but se...
Need Help
JoeKulasa's avatar
JoeKulasa
Regular Visitor
5 years ago

amitchandak 

Thanks - Index looks like it works properly, but I need the value to reset at the start of every new shift.  This is the purpose of Rank.  See below:

 

  • Rank doesn't add correctly, but resets @ shift change, which allows the measure to reset to 0
  • Index adds correctly, but doesnt reset @ shift change