December 20, 200619 yr 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.
December 20, 200619 yr 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 ) )
Create an account or sign in to comment