Let Function help

[Barry685]

I know this is easy but IM not particularly good at formulas.

Can you please redo this calculation using the "Let Function"

 

Sum(invoices|INVOICE_LINES::c_totalTax) *(taxRate/100) -

Sum(invoices|INVOICE_LINES::c_totalTax) *(taxRate/100)*discValue/100

 

Thanks

[jbante]

For example:

Let ( [
	~totalTaxSum = Sum ( InvoiceLine::totalTax ) ;
	~taxRate = taxRate / 100 ;
	~discountRate = discValue / 100 ;
	~totalWithoutDiscount = ~totalTaxSum * ~taxRate
] ;
	~totalWithoutDiscount
	- ~totalWithoutDiscount * ~discountRate
)

Another way to do it without any need for the Let function (though the Let function might still improve the readability) just takes a little algebra:

Sum ( InvoiceLine::totalTax ) * taxRate / 100 * ( 1 - discValue / 100 )

[Barry685]

Thanks wiil try it.