Hi Expert
i am trying to get the value "-" if the cell is Null or 0. and have 0% based on the calculation
Desired output
I want to insert the conditional in following formula, after data cleansing i already have Null values as 0 but now i need to insert "-" to all ) values.
Solved! Go to Solution.
can you provide some sample input values and expected output values?
Would an IF THEN ELSE formula work? I'm thinking something like:
if([32% /68% OTC and Appt Data]*100=0)
then "-"
else tostring(([32% /68% OTC and Appt Data]*100),0)+'%'
endif
Input:
OTC Data | Appt Data | OTC and Appt Combined | |
119% | 168% | 152% | |
39% | 90% | 73% | |
104% | 90% | 94% | |
99% | 73% | 81% | |
39% | 47% | 44% | |
55% | 46% | 49% | |
% | % | % |
Output data
OTC Data | Appt Data | OTC and Appt Combined |
119% | 168% | 152% |
39% | 90% | 73% |
104% | 90% | 94% |
99% | 73% | 81% |
39% | 47% | 44% |
55% | 46% | 49% |
0% | 0% | 0% |
always you are a life saver thank you.
Happy to help : ) @pokhan27
Cheers and have a nice day!