salestaxFromGross ( gross ; salexTaxPPT )
Gives you the tax part of the amount based on gross value
Average rating: 4.1 (32 votes) Log in to vote
Gjermund Gusland Thorsen
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
This function gives you the tax( tara ) from gross.
Peter Neal, London
Sep 14, 2010
I've adapted this custom function by adding the following:
Round( (salexTaxPPT / (100 + salexTaxPPT) * gross); 2)
This makes sure that only two decimal places are returned.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.