Brian Dunning's FileMaker Custom Functions

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   Gjermund Gusland Thorsen
Gudthlandum Consulting

Share on Facebook Share on Twitter

  Sample input:
salestaxFromGross( 1250; 25 )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This function gives you the tax( tara ) from gross.



Peter Neal   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.

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.