Forum Discussion

robs_au's avatar
robs_au
New Member
2 years ago
Solved

RUNNINGSUM Visual Calculation - stop after last value

I've been trying out the new RUNNINGSUM() Visual Calculation and it comes so agonisingly close to what I need. I'm comparing progress of an event against the previous two years.  The problem I get...
  • robs_au's avatar
    2 years ago

    I'm going to reply to my own post... actually having to write out and explain the issue I was having got the cogwheels turning some more and I figured it out.  I could delete my post but in the interest of potentially saving someone else finding themselves in the same confusion I was in, this was the solution:

    Running Points = IF(ISBLANK([Sum of Points]),BLANK(),RUNNINGSUM([Sum of Points]))

     

    Not that elegant, but it does the job.