Forum Discussion
MCFNeil
7 years agoQrew Captain
I'll try to help with the syntax, but the logic (what you need) is not crystal clear to me.
I think the IF statement logic is just a little mixed up.
When you have multiple if's together you don't need to provide the 'else' value in every line.
If(
question 1, true answer 1,
question 2, true answer 2,
question 3, true answer 3,
answer if all are false)
currently it looks like you have an 'else' answer for every question.
Basically you don't need the ", 0," after every line, but only at the end.
Secondly, you need to write the statement from top to bottom. i.e. Once it finds one correct answer it will use that, and not even check the rest.

I think the IF statement logic is just a little mixed up.
When you have multiple if's together you don't need to provide the 'else' value in every line.
If(
question 1, true answer 1,
question 2, true answer 2,
question 3, true answer 3,
answer if all are false)
currently it looks like you have an 'else' answer for every question.
Basically you don't need the ", 0," after every line, but only at the end.
Secondly, you need to write the statement from top to bottom. i.e. Once it finds one correct answer it will use that, and not even check the rest.
- JanaBaker7 years agoQrew CadetThanks Matt! Basically the only change needed was to remove this part. it wasn't needed. It allows the user to toggle the Day of Week to 0 or 8 thus creating a virtual "weekend" for shift workers.
[Cost Center Name] = "TO Service Mgmt" and [REG Override] = true,8 - Sum([FHL Form],[PTO Form],[JRY Form],[SCK Form],[Time without Pay Form],[Unscheduled PTO Form],[FNL Form],[FMLA Form],[HOL Hours],[Other Form]),0,