Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Iam adding column 1 and column 2 and getting this value on column 4 using the above expression and i have done group by also.
Try..
aggr((sum(PREPAYMENTAMOUNT_WITH_VAT)+sum(PREPAYMENT_AMOUNT_APPLIED)),COLUMN)
iam doing in a data load editor mam not in front end.
Are the comumns found int the same table or are they found in different tables?
Looking at the figures it looks like you have duplicates somewhere? What happens if you add a measure count(PAYMENT_AMOUNT_WITH_VAT) or a measure sum(PREPAYED_AMOUNT_APPLIED) to your table. Are any of them returning a value larger than 1? If so, then that is your explanation why you get those values.
It's from data model sir.. No duplicated values i checked that
load
COLUMN,
(sum(PREPAYMENTAMOUNT_WITH_VAT)+sum(PREPAYMENT_AMOUNT_APPLIED)) as field
Resident table
group by COLUMN;
Same wrong solution i get still.