Forum Discussion

eengle11's avatar
eengle11
New Member
3 years ago

Running Total On Graph

Sorry for the basic picture, I am trying to display a running total graphically, the darker blue represents Actual amounts, and the light Blue represents Projections. They should always follow each other as the projection changes based upon the actual amount. I would like for the Actual Line to stop when it no longer is following the Projection. I have found a work around by using a variable date, however different reporting schedules has caused this to become a less then ideal fix. Please let me know if there is a simple way to get the darker blue line to stop, based on when it deviates from the light blue. 

Show and Tell

1 Reply

  • vsorensen's avatar
    vsorensen
    Frequent Visitor
    3 years ago

    Try using an if statement

    IF(SELECTEDVALUE([date_column]) > [date_to_stop_graph], CALCULATE())

    Replace the 'CALCULATE()' statement with your running total calculation.