Expression Query

[#1]

hi all,

i have a straight table output:

region          VALUE          % Region

AMER               10               =10/80 ie 13%

ASIA                   20              =20/80 ie 25%

EMEA               50               =50/80 ie 63%

Total               80                    100%

% Region is desired column results i want but when use Sum formula in expression it takes values as below:

=10/10

=20/20

=50/50

please advise how to use sum function or aggregation function and what is the syntax

thanks

[Gysbert_Wassenaar · Accepted solution]

Use this expression: sum(VALUE)/sum(total VALUE)