
Re: wierd output using above
m w Mar 8, 2016 1:59 PM (in response to Tomas Hylander)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
Stefan Wühl Mar 8, 2016 2:04 PM (in response to Tomas Hylander)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
Tomas Hylander Mar 9, 2016 1:51 AM (in response to Tomas Hylander)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
jagan mohan rao appala Mar 9, 2016 7:56 PM (in response to Tomas Hylander)HI,
If you got the answer close this thread by giving Correct and Helpful answers to the post which helps you in finding the answer.
Regards,
Jagan.


Re: wierd output using above
jagan mohan rao appala Mar 9, 2016 2:03 AM (in response to Tomas Hylander)Hi,
I think the numbers seems to be correct, you can limit the numbers to two digits in the number tab.
Regards,
Jagan.