I have created a variable that does a calculation and shows a value. The variable is a Decimal and shows 10 decimal places. Can I shorten that to two?
Best answer by ghaiashish
View original
Userlevel 2
Use "round()" function on the responsive form, see screenshot.
+1
Perfect! So
ifElse([Form].[Gross_x0020_Up_x0020_for_x0020_T]==true,ifElse([Form].[Recipients Company]=="Company.",[Form].[Gross_IA],[Form].[Gross_SD]),[Form].[Amount])
becomes
round(ifElse([Form].[Gross_x0020_Up_x0020_for_x0020_T]==true,ifElse([Form].[Recipients Company]=="Company",[Form].[Gross_IA],[Form].[Gross_SD]),[Form].[Amount]),2)
Userlevel 2
Exactly!!
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.