Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to calculate Rangesum for above 12 rows only in Script?

Hi,

I need to calculate the RangeSum of Current month with above 12 month,

like this I need to calculate it for every month,

I'm having a table like this

Capture1.JPG

and I need answers in this way,

Capture2.JPG

11 Replies
Anonymous
Not applicable
Author

Thanks Mate ,

I've deleted this extra field in the code (Peek(Value,-12))

and It works fine.

Thanks for your Time.

jyothish8807
Master II
Master II

You are welcome. you can close the thread if you have got the answer

Best Regards,
KC