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