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
http://www.gudthlandum.no

Share on Facebook Share on Twitter

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

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

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

 

Comments

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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.