AnsweredAssumed Answered

Calculated If statement

Question asked by NEOMAPPER on Oct 12, 2020
Latest reply on Oct 12, 2020 by NEOMAPPER

How do you write an If statement based on a value from previous fields. If TYPECODE = 3 and MCF is > 500 calculate 1801 Engineering Dept as the answer? My statement below doesn't seem to work. Any help would be appreciated!

 

 

${TYPECODE}='3' and if(${A00MCFTOTAL}>500,"1801 Engineering Dept"))

Outcomes