Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Same day date difference resulting in negative value

Hello PBi Community   -   So I have the formula below which works great for calculating the number of weekdays between two dates.    I then use the result of this to tell me whether a shipment is on ...
Need Help
  • TomMartens's avatar
    TomMartens
    6 years ago

    Hey Anonymous ,

     

    as both dates are equal, the FALSE branch will be evaluated, and this means that the 1 row will be multiplied with -1

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey Anonymous ,

 

as both dates are equal, the FALSE branch will be evaluated, and this means that the 1 row will be multiplied with -1

 

Regards,

Tom

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Thanks Tom. Is there an easy fix?