I have a pivot chart in which i have five calculated expressions.
I need to find the maximum of Net Long Positions and Net Short Positions.
I have used the formula,
Max([Net Long Position],[Net Short Position]), but it shows a null value.
Can someone please help and let me know how to get the maximum of the two expressions.
Solved! Go to Solution.