Forum Discussion

newgirl's avatar
newgirl
Post Patron
3 years ago
Solved

Conditional Formatting for Div 0

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.

Need Help

2 Replies

  • henkvankester's avatar
    henkvankester
    Helper I
    3 years ago

    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'

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    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.