Forum Discussion
nisha_deepak
Helper III
5 years agoreplace blank with 0.00 for decimal number
i tried to replace blank value of column which is of type decimal number to 0.00 .
I create new column
if(ISBLANK([column1]),0.00,[column1]) ...but am getting 0 instead of 0.00.
If i put 0.02 in custom column...it is correcting getting values as 0.02.
plse help...
nisha_deepak , In the measure/column tool change it two decimal place and check
Screen shot is indicative
1 Reply
- amitchandak
Super User
nisha_deepak , In the measure/column tool change it two decimal place and check
Screen shot is indicative