Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem to cumulate result on a tab.
Check screenshot and my application.
On the line L3 Y2D i want to sum the data of L3 :
In january : 6
In February : 6 + 2
In March : 6 + 2 + 2
In April 6 + 2 + 2 + 2
Thank you very much,
Regards!
Hi Emilien,
Look at the file attached.
Your intuition was almost right, but in this case you want to accumulate Columns instead of Rows, so you have to use Before() function instead of Below.
Example :
RangeSum(Before(TOTAL sum(TARGET.TARGET_L3),0,ColumnNo(TOTAL)))
Regards,
Benoit
Up!!
Hi Emilien,
Look at the file attached.
Your intuition was almost right, but in this case you want to accumulate Columns instead of Rows, so you have to use Before() function instead of Below.
Example :
RangeSum(Before(TOTAL sum(TARGET.TARGET_L3),0,ColumnNo(TOTAL)))
Regards,
Benoit
Merci Benoit ça correspond exactement à ce que j'attend.
Bonne journée!