Skip to main content

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?

Use "round()" function on the responsive form, see screenshot.


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)


Exactly!!


Reply