Hi Members,
Need help in the attached scenario. Problem is that when i calculate rolling total on expression level it works fine for smaller data set but for huge data set it took too much time. So i try to did it on script level but i didn't know what's the mistake i made that my result didn't matched. Running Total 1 is calculated on expression level (Correct) but Running Total 2 is calculated on script level (Wrong). Please find the qvw and qvd in attachment.
Thanks,
Arsalan