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])/[...
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())
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())