3 Replies Latest reply: Dec 7, 2012 4:12 AM by Jonathan Dienst RSS

    how to use sum function on virtual field?

    Vishwaranjan Kumar

      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