Calculation with OR

Hey Anonymous

The OR clause should look like:

(Table[REASON]="Not well" || Table[REASON]="Left the job")

Hope this helps,

Parker

Hi Anonymous

As mentioned Anonymous, the OR syntax needs to be changed. Also, the last year part wont retun as expected in your code, you need to change the code as below:

Total Number = CALCULATE(COUNT(Table[Total]), 
      YEAR(Table[DATE])=YEAR(TODAY())-1  
      && (Table[REASON]="Not well" ||Table[REASON]="Left the job") 
      && Table[Gender]="F"))

Thanks

Raj