Forum Discussion
Rounding decimals based on another column value
Need help with rounding the numbers in a column called "LabResults" based on values from other column called "LabTestName" , a single column has various lab tests, the requirement is to show the measurement values with different decimals for different tests.
Example
LabTestName LabResults
T1-272 20.1 (1 Decimal point)
T1-300 54.4218 (4 decimals)
TBP 30 ( No Decimals)
TS-200 70.42 (2 Decimal points)
TCL-100 40.9 (1 Decimal Point)
Any suggestions would be highly appreciated.
Hi,
The columns names got melted together and i used 20.1111 as values for all entries, but this should do the trick, no :)?
2 Replies
Hi,
The columns names got melted together and i used 20.1111 as values for all entries, but this should do the trick, no :)?
Thank you so much. The logic worked for me. Thanks for your help!
