Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello
I need to calculate the sum of a column and put it in an other one.
How can I do that?
If the column name is for example COLXX (where you compute sum(nn)) then in the other column you can wrire
[COLXX] having, in this way the same result
I didn't get it
I created a table with 2 columns and one dimension
dimension= product
column1= quantity
column2=quantity/ sum(column1)
it doesn't work for the 2nd column
column2=quantity/ [column1]
the syntax for column is column(n) where n is the number of expression starting from 1
syntax error
it doesn't work
Hi,
Try like this
quantity/ sum(TOTAL quantity)
Hope this helps you.
Regards,
Jagan.
thx