Forum Discussion

stackover's avatar
stackover
Frequent Visitor
2 years ago
Solved

Combining running totals with selected date value

Hi guys. How are you doing? It has been a week that I am trying to do the following. I hope you guys can help me.   - I have two running totals. One is a baseline and it should be static (problem n...
Need Help
stackover's avatar
stackover
Frequent Visitor
2 years ago

Thanks for the file, but unfortunately I think I wasn't clear about what I would like to achieve. The selectable date in the slider is a cutoff date, that is, the running total of the database table goes up to the date selected in the slider and after that the running total continues to add up taking the values from the baseline table.

Would this be possible to do?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Not sure I understand. You said the second screenshot was the expected result.  Please clarify/provide another screenshot.

  • stackover's avatar
    stackover
    Frequent Visitor
    2 years ago



    I think in this graph it is possible to see what I am trying to explain. Sorry if I am not able to make it very clear. Note that the total running on the left side of the red vertical line refers to the RT-Database line and after Jul/24 (right side of the red line) the running total will receive the values from the RT-Baseline line.

    It is a running total made up of the two tables. Until a selectable date it takes the values from the Database table and after that it continues the total running taking the values from the Baseline table. I hope I was able to explain.