
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?