PC: Business rule: Adhoc query not giving desired result

[plaban_sahoo6]

Hi All,

I have line items of the same vendor(from LFA1) and its related amount(from BSAK),in a Data Source. I have created a Business rule, where i want to calculate the total(amount) for each vendor.

So, i have below fields, in my 'data For analysis'

Account number of Vendor or Creditor

Amount in document currency

Currency Key

Since i want to select all records, with currency as EUR, i have put filer as Currency(EUR)

So, i have created a Calculated Field in Conditions and Columns for 'Grouping and Aggregaton', with Group field as Account number of Vendor/Creditor', , Select Aggregation method as 'Sum' and Select field for aggregation  as 'Amount in document currency'

but my AD-HOC QUERY is not giving the total amount for each vendor. Could you resolve this issue

Regards

Plaban

[plaban_sahoo6]

hi All,

Any suggestions on this

Regards

Plaban