Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need a running sum

From 2 tabels (Bank account and Forecast)  I have the following information.

           

Date (T1 and T2)Current Account Balance (T1)Forecast (T2)Running Sum
01/0110050100
02/0111090110
03/0100110
04/01050160
05/010- 40120
06/0100120
07/01080200

I need a running sum (03/01) from the moment the last Current Balance is know.  How can this be calculated?

Thanks

John

1 Solution

Accepted Solutions
sreenivas
Creator III
Creator III

Hi

Please find the attached file hope it helps you requirement.

View solution in original post

4 Replies
sreenivas
Creator III
Creator III

Hi

Please find the attached file hope it helps you requirement.

Not applicable
Author

Thanks very much. This works !!

Not applicable
Author

Hi,

This workds. Thanks very much for your help.

Not applicable
Author

Hi,

Try this sample file

Best of luck