Hello, I'm tyringg to setup the taxable amount and total amount calculation fields in my sales invoice report
So basically, the taxable amount should be Unit price*qty- disc%-total disc%.
the field LineAmountIncltAX Is a standard field that already calculates the unit price*qty-disc%.
so i added this expression: =Fields!LineAmountInclTax.Value-Sum(Fields!Ex_SalesDiscPercent.Value, "SalesInvoiceHeaderFooterDS")
to be LineAmountInclTax - the total disc% field that is from another data set but its giving wrong calculation
Also regarding total amount, im using LineAmount standard field but also giving wrong calculation.
anyone can help please?


Report
All responses (
Answers (