Author Topic: Formula for missing data  (Read 825 times)

Offline reportit

  • Full Member
  • ***
  • Join Date: Apr 2013
  • Posts: 8
  • Forum Citizenship: +0/-0
Formula for missing data
« on: 25 Apr 2017 05:04:57 pm »
I need a formula that will show 'YES'  if the employee is in the status of 'Full Time'  does not have a Benefit plan of 'Medical', otherwise the cell needs to be blank.

I tried but it didn't work:

IF (([Status] in ('Full Time')) and (([Benefit Plan]='Medical') is missing)) then ('YES') else Null

Does anyone have any idea of a formula that would do what I need?

Thanks!

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,231
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Formula for missing data
« Reply #1 on: 26 Apr 2017 04:57:59 am »
I need a formula that will show 'YES'  if the employee is in the status of 'Full Time'  does not have a Benefit plan of 'Medical', otherwise the cell needs to be blank.

I tried but it didn't work:

IF (([Status] in ('Full Time')) and (([Benefit Plan]='Medical') is missing)) then ('YES') else Null

Does anyone have any idea of a formula that would do what I need?

Thanks!

How about:

IF ([Status] = 'Full Time' and [Benefit Plan] <> 'Medical') then ('YES') else (Null)

MF.
Meep!

 


       
Twittear