locked
Building a Total formula for custom Quote report RRS feed

  • Question

  • Dear all,

    I have a total calculation area for a quote which is on Sub Total- Discount value.

    IN order to do that I have a field name Sub Total which has an expression value of :

    =Sum(Fields!extendedamount.Value, "ProductListDataSet")

    From that I get the total amount of the product list . Then in order to get that toal amount I need to take in account the possible DiscountValue. For that I have a field name Total which has an expression value of :

    =Sum(Sum(Fields!extendedamount.Value, "ProductListDataSet")-Sum(Fields!extendedamount.Value, "ProductListDataSet")*Fields!discountpercentage.Value / 100)

    When doing so I get the following error :

    "Inner aggregate cannot specify a dataset scope"

    How can I solve this  ?

    Thanks for help

    reagrds


    Your knowledge is enhanced by that of others.

    Wednesday, July 16, 2014 2:51 PM

Answers

  • solve it. There are ready internal fiels which contains total already

    Your knowledge is enhanced by that of others.

    Thursday, July 17, 2014 1:52 PM