Currently I have three rows in a criteria (A, B & C).
I want to change C so that is equals A / ABS(B).
I have tried using a custom calculated item in the results set but it won't allow the use of ABS.
Is this possible without the use of a union?
You can apply this logic in the column formula.
I couldn't work out how to?
I ended up having to add a union and then use the filter function to access each row separately in the same column.