Conditional Formatting for Div 0

[newgirl]

Hello!

I think I'm mising a logic in my conditional formatting for my measure. My measure is cmparing the YTD overtime days with the Previous year YTD overtime days. However, there's a value wherein a department has overtime this year but no overtime last year so when computing manually, this would return as error.

However, in my conditional formatting, it's showing as -100%. Is there a way to make the icon fall under the category as [red arrow up], meaning their overtime increased from previous year.

[v-yadongf-msft · Accepted solution]

Hi @newgirl ,

Please try:

Diff = IF(NOT(ISBLANK([PYYDT%])),DIVIDE([Duty_YDT],[Duty_PYYDT])-1,[YDT%])

The result you want:

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[henkvankester]

Probably you should use next values: 

If value > 0 procent  and < 0 number then 'arrow down'

and

If value >= 1e-11 number and <= 100 procent then 'arrow up'