Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Your rate is having a comma instead of decimal....so it is not a number anymore.
Thanks,
Singh
Hi
Please attach your file
Thanks
Hi!
Take a look on the attached file.
Regards,
Gabriel
Hi, in Lithuanian Locale it is numeric field. thanks
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.
files attached.
Hi!
I've changed a few things. Take a look again, please.
Regards,
Gabriel
no luck.
please see updated file, also with some examples of calculation in .xls sheet 2
Hi
Expression should be as follows SUM(untaxed_amount_cache / rate)
See attached
Cheers