Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Number Format - Total

Hi all,

I need to know how to remove total on the "Number Format" column

Number Format = IF(SUM('Table'[Number]) = INT (Sum('Table'[Number])),

FORMAT(SUM('Table'[Number]),"#,#"),

FORMAT(SUM('Table'[Number]),"#,0.00"))

Anonymous

Finally its works with

Column =
IF (
    Table[Number] = INT ( Table[Number] ),
    FORMAT ( Table[Number], "#,#" ),
    FORMAT ( Table[Number], "#,0.00" )
)