Percentage Value

[skorpion]

 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())

[Greg_Deckler · Accepted solution]

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())