Forum Discussion

skorpion's avatar
skorpion
Helper I
8 years ago
Solved

Percentage Value

 the problem is this formula giving text formt but i need this as Percentage please help me out on this

 

 

Diff. = IFERROR(IF([This Year Total] = 0.00 , "",([This Year Total]-[Last Year Total])/[Last Year Total]),BLANK())

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    I *think* you just need to do this:

     

    Diff. = IFERROR(IF([This Year Total] = 0.00 , 0,([This Year Total]-[Last Year Total])/[Last Year Total]),BLANK())

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    I *think* you just need to do this:

     

    Diff. = IFERROR(IF([This Year Total] = 0.00 , 0,([This Year Total]-[Last Year Total])/[Last Year Total]),BLANK())