I am having a field that has type p decimals 1. now i need to format this field in a specific manner.
if the value is 4.0 then i want to output 4 and if output is 5.6 then i want to output 5.6.
i was wondering how to achieve the formal. I tried "shift right" but dint work; One of the possible solution is checking the last digit and if it is 0 and then is preceded by point i need to delete both of the digits. any other solutions??
will wait for your expert input.
thanks and regards,