Powerpivot IF or Isblank Formula Help

[sjuhl99]

I am attempting to write a formula and getting a syntax error and looking for help. I have a related column coming [quantity late] that is either blank or has a number. I am trying to say if the column [quantity late] is blank or 0 put a 0 in my new calculated column otherwise divide. My Formula is below. Thanks


=IF(ISBLANK([Quantity Late]),"0",[Quantity Late]/[On Order]))

 

[Matt Allington]

IF cannot have 2 different data types as the options. Your first is a text and second is a number. Try this

=IF(ISBLANK([Quantity Late]),0,[Quantity Late]/[On Order]))