help with variable

[#1]

Hello

I have the following and it works fine, just send me a variable to zero, I could support if well done telling my variable using RANGESUM

Temp:

Load sum(DATA) as totSales
Resident VentaOriginal
Where AGRUPADOR='01_VENTAS';

Let vTotSales = peek('totSales',0,'Temp');  --------->This variable is well,
Let vSales = Rangesum(totSales);  ---------> This variable just send zero.

Help me

[#2]

RangeSum cannot be applied this way in script. What is that you want to have in vSales variable?

Kiran.

[#3]

I want the sum of DATA, how could it get?

[#4]

I think thats what you are getting in vTotSales. How is this sum different from vTotSales?

Kiran.

[#5]

ok thanks, and you understood what I did was create a temporary table and create what I needed there.

Another thing as I do in my field acumudalo DATA. I put the following

Rangesum (peek ("ACUMULADO"), DATA) as ACUMULADO

but the moment in a pivot table compare this with data and accumulated option does not give me the same result.

[#6]

For accumulation I use numsum function. Please refer help on this: Interrecord functions -> Peek Function last example. Hope it helps you.

Kiran.