Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6609 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I'm having some trouble figuring out where to put my parentheses in my embedded calculations. For example, I want to round the total for the sales tax (we have a line on our invoice that calculates tax on each item). It looks like:

Sum ( Sales Tax )

but when I try Round (Sum(Sales Tax) its telling me my parameters are off. Likewise, for my Cash Back calculation:

Case ( Transaction Type = "cash";Amt. Received - Order Total ) Where would the "Round" go?

Thanks for listening to the woes of a newbie.

Posted

Round requires the number of places to round to:

Round ( 126.67123 ; 2 ) = 126.67

Round ( 126.67123 ; 1 ) = 126.7

Round ( 126.67123 ; 0 ) = 127

Round ( Sum ( YourField ) ; 2 )

Round ( Sum ( Sales Tax ) ; 2 )

Case ( Transaction Type = "cash" ; Round ( Amt. Received - Order Total ; 2 ) )

This topic is 6609 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.