on 10-13-2015 7:26 AM
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
hi All,
Any suggestions on this
Regards
Plaban
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.