Multiplying by a Blank

Question

Hi Folks,&nbsp;I currently have 1 * blank = Blank, id like to get 1 x Blank = 0 if possible.&nbsp;Thanks&nbsp;

dinesh_suranga · Answer

BarryRussell2&nbsp;HiTty following.IF ( 1 * Blank () = Blank() , 0 ,&nbsp;1 * Blank ())Thank you.

barryrussell2 · Answer

Thanks Dinesh

dinesh_suranga · Answer

BarryRussell2&nbsp;If my formula solved your problem,Pleas accept it as solution.Thank you.

barryrussell2 · Answer

Hi, just working on it now

barryrussell2 · Answer

Hi Dinesh,&nbsp;Can you help with with this please, so at the moment I have&nbsp;OEE Daily = [Availabilty]*[Total Performance]*[Total Quality]Where would I apply the formula? the above is a measure already.&nbsp;Thanks

Forum Discussion

Multiplying by a Blank

5 Replies

Related content

Blank Page - Embedded Report

multiplier

Multiply and return BLANK

Counting Non-Blank Records

IF and Multiply