Forum Discussion
Sqrt in Column
Hello Everyone! I want to calculate the SQRT of a column, I have a table like this: I just need de Sqrt Value of the "P Value" column, i use the following formula: P Lote = SQRT('PQ...
Hi Anonymous
The problem lies in the data type used for this calculated value
I recreated your scenario and below is the formula I would use.
P Lote = SQRT(VALUE('PQI Lote'[P Value]))Below is the ouput I get:
Try
P Lote = ROUNDUP(SQRT('PQI Lote'[Z Value]),1)
Hello Anonymous thanks for replying, unfortunately that formula didn't worked
the error was the same
Any other idea?