Report Builder - Sum(Fields!Qty.Value * Fields!Price.Value) gives an error.

Chetan

Hi All,

I have query in reference to SQL Report Builder.

I am trying to obtain the Total value using the below expression, but I am getting an #Error in the report.

=Sum((Fields!MKG_Amt.Value) * (Fields!WeightQtyInvoiced_SalesInvoiceLine.Value))

Is their any way to resolve it in the report builder or should I have to create global variables and pass it them through dataitems and calculate the value in the C/AL Editor ?

Many Thanks for your help in advance.

Chetan

Hi Everybody,

I got the required result.

I did created the three variable and passed through DataItem and calculated them in "Sales Invoice Line - OnAfterGetRecord()".

Then considered the sum of only individual variable/field in the Report.