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 wher...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    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.

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'