Hi everyone,
Really not sure what I'm doing wrong here. I have the following IF statement:
IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) END
I keep getting that Malformed error message regardless how I wrap the 1 whether it ends with END or ENDIF.
RecordID is a calculated field, so perhaps that's the issue?
Any help would be appreciated!
Solved! Go to Solution.
Hello @Goran
You are missing the else statement
IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) ELSE <SOMETHING HERE> ENDIF
for example:
IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) ELSE [Core Time] ENDIF
Regards
The syntax should be:
IF [RecordID] = 1 THEN ([Core Time]+[Work Out]) ELSE '' ENDIF
Thank you. I didn't realize IF statements always needed to have an ELSE