Forum Discussion
Solved
Custom Format Measure column to add brackets/parentheses to negative numbers
Hi all, My finance department has asked that the currency columns be format from -£5,000 to (£5,000) I've tried a few options but I can't get this to work when the column is a measure... Var...
Do it in two steps:
Measure 2 = VAR myCalc = CALCULATE(100) RETURN FORMAT(myCalc,"£#,##0;(£#,##0)")
Unfortunately this doesn't work with Calculate...
The formula for the measure works as expected, but as soon as I add the FORMAT(CALCULATE( it breaks.
Error in Table
Do it in two steps:
Measure 2 = VAR myCalc = CALCULATE(100) RETURN FORMAT(myCalc,"£#,##0;(£#,##0)")