Multiplying by a Blank

[BarryRussell2]

Hi Folks,

I currently have 1 * blank = Blank, id like to get 1 x Blank = 0 if possible.

Thanks 

[Dinesh_Suranga]

@BarryRussell2 

Hi

Tty following.

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

Thank you.

[BarryRussell2]

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

[BarryRussell2]

Thanks Dinesh

[Dinesh_Suranga]

@BarryRussell2 

If my formula solved your problem,

Pleas accept it as solution.

Thank you.

[BarryRussell2]

Hi, just working on it now