TRANSFORM AN ABSOLUTE FORMULE

[Sara_Bertomeu]

Hello, I try to transform this formule SUM(R2C[-5]:RC[-5]), with an absolute data. Can you Help me?

SUM(R2C[-5]:RC[-5]) in excel "=SUMA(G$2:G2)"

RC[-5] is [TOTAL VTAS] 

R2C[-5] is the absolute data G$2

And the same for: =Sum(E$2:E3) 

SUM(R2C[-6]:(RC[-6]+1))

Thanks Sara

[Marc_Dillon · Accepted solution]

Like a running total?

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?advanced=false&allow_punctuati...

[Marc_Dillon]

It is recommended to not use Spreadsheet Formulas. Convert them into Appsheet expressions. I'm not about to try and decipher your spreadsheet formula, please describe what you're wanting to calculate in plain language.

[Sara_Bertomeu]

Thanks Marc, 

Yes I know it's not good, this is the reason I'm looking for a Appsheet formule. 

I need the Total amount for SUM(R2C[-5]:RC[-5]), I want to SUM

(R2C[-5]:RC[-5]), the Row 2 in column [VTAS ACUMULADO] but the first item, and then sum the next and then the next amount. 

Like adding the next amount to the data before.

Thanks Marc

[Marc_Dillon · Accepted solution]

Like a running total?

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?advanced=false&allow_punctuati...

[Sara_Bertomeu]

I do not know the name in English, sorry!!! let me check!!

[Sara_Bertomeu]

Yes running total. Thanks Marc. 

How can I be like you when I will be old, CLEVER CLEVER CLEVER!!!

GRACIAS

[Sara_Bertomeu · Accepted solution]

The other solution that I need for adding the after item to the next I founded. 

SUM(SELECT(VENTAS [Unidades],([TOTAL UNIDADES] <= [_THISROW].[TOTAL UNIDADES])))

thanks sara