Forum Discussion

erihsehc's avatar
erihsehc
Icon for Helper III rankHelper III
8 years ago
Solved

number formating issue

hi there,   I would like the number format in %, however, when I used formula ratio% = IFERROR(SUM(Sheet1[sales])/SUM(Sheet1[cost]),"na"), the result cannot be formatted in %, how to solve this? th...
Need Help
  • GilbertQ's avatar
    GilbertQ
    8 years ago

    Hi erihsehc

     

    This could possibly done by using the Format as shown below.

    My Measure =
IF (
    [Net Win] > 100,
    "nm",
    FORMAT ( DIVIDE ( SUM('Table1'[sales]), SUM('Table1'[Other Sales]), "NA" ), "Percent" )
)
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi erihsehc,

As GilbertQ posted, there is no way to format the measure. Please mark the solution GilbertQ shared as answer because it resolve your issue. So that more people will get useful/helpful reply as answer.

Best Regards,
Angelia

erihsehc's avatar
erihsehc
Icon for Helper III rankHelper III
8 years ago

ok thanks for the help:manhappy: