I have 2 columns "Unit of Measure" and "Value".
There are two unit of Measures: PPM and %. I want to create a new column that wherever unit of measure is %, the result is value*10000, if unit of measure is PPM, result is value. The formula is giving the result but when i try to put filter, it's giving an error: Convert Data into number, Details: Balance.
I tried changing data type into number, still i am unable to filter.
If i am not adding "If [Unit of measure]="%" then [value]*10000, then formula and filters are working fine. Please help me with solving this as i want to add this condition