I have a field that I am using for percent column section, If the field has a value in it then it would show the value as a percent, but If the field has no value I do not want anything to show up in the column including the percent sign. So far I can not get the view just to show nothing. In the column where no value has been enter it % sign or a zero.
The field on the form is a Dialog List where the user gets the numbers from
Thanks in advance for any help
@If(@Contains(Percent2;“100”);0.1;
@Contains(Percent2;“99”);0.99;
@Contains(Percent2;“90”);0.9;
@Contains(Percent2;“80”);0.8;
@Contains(Percent2;“70”);0.7;
@Contains(Percent2;“50”);0.5;
@Contains(Percent2;“30”);0.3;
@Contains(Percent2;“10”);0.1;
@Contains(Percent2;“5”);0.05;
@Contains(Percent2;“1”);0.01;“”)