how to use sum function on virtual field?

[#1]

hi Everyone

please help me with this....

In a chart properties  of pivote chart , i have two expressions labelled ie... [no. of quantity] and [new_price]

iI want to get another expression which is the Product of the above two. and it should also show the Subtotal value .

i have written

sum([no. of quantity]*[new_price] ))

but the summation of the product is not working althogh I am getting the product.

thanks in advance

[#2]

Hi,

What do you mean by "I am getting the product"? I have noticed that your fomula exceeds 1 closing parenthesis. Maybe it will fix your problem.

Regards,

Janzen

[#3]

sum([no. of quantity]*[new_price] )

by mistake i wrote that , but it does not work

[jonathandienst · Accepted solution]

Hi

Although you can use named columns or Column() to refer to other columns in a table or chart in your expressions, unfortunately you cannot use aggregation functions (like Sum, Avg, Min).

So you will need to substitute the expressions for [no. of quantity] and [new_price] to perform this calculation

Regards

Jonathan