I need help with one of the number format issue. The MIN formatted and MAX formatted column shown are calculated as below:
However when i export this actual values are MIN and MAX in excel.
I want to achieve the values in the MIN used_calculation and MAX used_calculation as MIN formatted and MAX formatted so that my calculations are correct in excel. I have tried Floor, Ceil and Round function but none of them are giving the results in the formatted columns MIN formatted and MAX formatted.
The result which is shown by Num() function, i need similar kind of result for calculation in another column. but i am not sure if at all Num() function is giving the correct result in the first place.
Since i have to use the result, Number formatting wont help in that case.
I am still not sure why you are not able to use formatting on the number tab... would you be able to share a sample which can show us the issue you are running into when you use formatting on the number's tab?