Cumulative Sum creation Error?

[chandrasekhar6]

Hi All,

Can I created Cumulative sum of salary based on Department Number but last row calculated only previous row only.

Custom function and Error attached as below.

Thanks,

Chandra

[former_member187605 · Accepted solution]

Almost correct

This will work when you define $PREV_DEPT and $PREV_SAL as global variables instead of parameters (that are local to the call).

Make sure you initialise them properly before your first function call.

[chandrasekhar6 · Accepted solution]

Hi Drik Venken,

Thanks for your response.

When I remove $PREV_DEPT and $PREV_SAL local variables and assign global variables it shows

as below.

Thanks,

Chandra

[former_member187605 · Accepted solution]

That simply means you haven't redefined them as a global variable yet.

Or you're testing your function outside of the context (project & job) where they are defined.

[chandrasekhar6 · Accepted solution]

Thanks Drik for your valuable suggestions