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.

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.