5 Replies Latest reply: Mar 9, 2016 7:56 PM by jagan mohan rao appala

# wierd output using above

Hi,

I've got several meter readings and wish to calculate the diffrence with current and last read reading.

When using above in a expression "sum(varde) / above(sum(varde))", I get wierd sums. What is it Im missing?

See the picture for example.

• ###### Re: wierd output using above

I didn't bother checking, but the sums look approximately correct to me.

for row 2, the sum is 44910.3. the sum(above) is 44843.9. If you divide those numbers, the answer should be slightly larger than 1.

• ###### Re: wierd output using above

The numbers seem correct to me,too. What do you expect to see / why do you think the numbers are weird?

If you want to calculate the difference, use

sum(varde) - above(sum(varde))

• ###### Re: wierd output using above

argh, crap...cant work on several projects at the same time.

Of course it looks wierd when you use the wrong calculation.

yes, its subtraction Im after, I mixed it up with another chart, shame on me.

thanks for clearing that out

• ###### Re: wierd output using above

HI,

Regards,

Jagan.

• ###### Re: wierd output using above

Hi,

I think the numbers seems to be correct, you can limit the numbers to two digits in the number tab.

Regards,

Jagan.