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.