sum (values0*value1) question

[#1]

Dear All,

i am having some issues with following situation, data table:

name	price	rate
1	1000	0,5
2	2000	0,5
3	2000	0,9

I am trying to use expression in chart, to have total amount of rows, which is equal to price*rate. I am ussing expression SUM (price*rate), which gives me totaly wrong results.

Any suggestions?

Thanks!

[#2]

Your rate is having a comma instead of decimal....so it is not a number anymore.

Thanks,

Singh

[d_pranskus]

Hi

Please attach your file

Thanks

[Anonymous]

Hi!

Take a look on the attached file.

Regards,

Gabriel

[#5]

Hi, in Lithuanian Locale it is numeric field. thanks

[#6]

this works, but if I create one chart like this (table), i want to create other chart (bar graph) which uses sum of these Value 2 fields. And I cannot select this expression.

Formula in Value1 - shows incorect results.

[#7]

files attached.

[Anonymous]

Hi!

I've changed a few things. Take a look again, please.

Regards,

Gabriel

[#9]

no luck.

please see updated file, also with some examples of calculation in .xls sheet 2

[d_pranskus]

Hi

Expression should be as follows SUM(untaxed_amount_cache / rate)

See attached

Cheers