Nagasaki Posted December 20, 2006 Posted December 20, 2006 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.
Stuart Taylor Posted December 20, 2006 Posted December 20, 2006 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 ) )
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now