Showing results for 
Search instead for 
Did you mean: 

Compute Formula If condition?

Compute Formula If condition?


I am getting an error for the below formula of If condition for multiple columns. Please help me with the correct syntax.

if (@Savings Year@ =2020 OR @Carry Over Year@ =2020 OR @Carry Over Baseline Year@ =2019 OR @Project Status@ ='Awarded', @Annualized Savings@ , 0 )

Labels (1)
2 Replies

Hi Praveen - glad you figured it out, that's exactly what I was about to suggest!  The OR condition will return a 'true' boolean value if any of the conditions included are true so putting an "If" statement around that is the most efficient way to solve.

Got the solution!!

if (OR(@Savings Year@ =2020, @Carry Over Year@ =2020,@Carry Over Baseline Year@ =2019,@Project Status@ ="Awarded"), @Annualized Savings@ , 0 )