Forum Discussion

BarryRussell2's avatar
BarryRussell2
Regular Visitor
3 years ago

Multiplying by a Blank

Hi Folks,   I currently have 1 * blank = Blank, id like to get 1 x Blank = 0 if possible.   Thanks 
Need Help
Dinesh_Suranga's avatar
Dinesh_Suranga
Continued Contributor
3 years ago

BarryRussell2 

Hi

Tty following.

IF ( 1 * Blank () = Blank() , 0 , 1 * Blank ())


Thank you.

  • BarryRussell2's avatar
    BarryRussell2
    Regular Visitor
    3 years ago

    Thanks Dinesh

    • Dinesh_Suranga's avatar
      Dinesh_Suranga
      Continued Contributor
      3 years ago

      BarryRussell2 

      If my formula solved your problem,

      Pleas accept it as solution.

      Thank you.

      • BarryRussell2's avatar
        BarryRussell2
        Regular Visitor
        3 years ago

        Hi, just working on it now

  • BarryRussell2's avatar
    BarryRussell2
    Regular Visitor
    3 years ago

    Hi Dinesh,

     

    Can you help with with this please, so at the moment I have 

    OEE Daily = [Availabilty]*[Total Performance]*[Total Quality]
    Where would I apply the formula? the above is a measure already.
     
    Thanks