In my report I calculate VAT for Invoices In and for Invoices Out with this formula.
=Nz(Sum([AmountExVAT]*[VRate]),0)
There is an InOut Header and the calculation is in the InOut Footer
In the Report Footer how do I calculate the differnece between Invoices In and Invoices Out. And if the In value is higher have a + value and if the Out Value is higher have a - value.
Thanks
=Nz(Sum([AmountExVAT]*[VRate]),0)
There is an InOut Header and the calculation is in the InOut Footer
In the Report Footer how do I calculate the differnece between Invoices In and Invoices Out. And if the In value is higher have a + value and if the Out Value is higher have a - value.
Thanks