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?
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156