Nagasaki Posted December 20, 2006 Share 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. Link to comment Share on other sites More sharing options...
Stuart Taylor Posted December 20, 2006 Share 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 ) ) Link to comment Share on other sites More sharing options...
Nagasaki Posted December 21, 2006 Author Share Posted December 21, 2006 Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6308 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