Multi conditional statement

[MHS]

Happy new year everyone!

Was hoping that someone in the community would be able to assist with a conditional statement that I am writing in the formula tool.  When running the workflow I am getting an error message that reads "The field "" is not contained in the record".  The data that I am working with is formatted as an integer.

IF [Group By_JIRA Form] = "Capability" THEN
54*(((6*.5)*([Created count]+[Updated count])/60/60))
ELSEIF [Group By_JIRA Form] = "Capability ROM" THEN
54*(((3*.5)*([Created count]+[Updated count])/60/60))
ELSEIF [Group By_JIRA Form] = "Epic" THEN
54*(((4*.5)*([Created count]+[Updated count])/60/60))
ELSEIF [Group By_JIRA Form] = "Story" THEN
54*(((7*.5)*([Created count]+[Updated count])/60/60))
ELSEIF [Group By_JIRA Form] = "Project Task" THEN
54*(((13*.5)*([Created count]+[Updated count])/60/60))
ELSE "Null"
ENDIF

Any help would be appreciated!

[mmenth]

Did you name the new field you are trying to make? It's easy to forget as it says 'Select Column' until you select an existing column or enter a new one.

Best,

mmenth

[MHS]

Hi Bolide, 

Yes I named the column.  Just wondering if anyone had any info on that error message.

Thanks, 

Matt

[mmenth]

Hmm I've only seen that error when a formula is missing a column name. I would double check your other formula tools in the workflow, or if possible, upload the workflow here so that we can take a look. If you haven't done this before, go to Options -> Export Workflow, this will give a yxzp which others can import without having your raw data.

[Jonathan-Sherman]

Hi @MHS,

Did you manage to export as a packaged workflow for us to take a look?

Regards,

Jonathan

[MHS]

Hi Guys,

Attached is the workflow, thanks again for all the help!

Matt

[ashissanpui]

@MHS  you formula seems to be OK. This might be the issue with your new field data type or one of the filed from your file is missing.

AShis

[echuong1 · Accepted solution]

Your second formula in the formula tool needs to have a column name specified.

Also, the syntax for the second formula is incorrect. The "ELSE" statement cannot have conditions in it. I would change the last ELSE to be ELSEIF and then have ELSE NULL() at the end before ENDIF. See below: 

IF [Group By_JIRA Form] = "Capability" THEN
54*(((6*.5)*([Created count]+[Updated count])/60/60))
ELSEIF [Group By_JIRA Form] = "Capability ROM" THEN
54*(((3*.5)*([Created count]+[Updated count])/60/60))
ELSEIF [Group By_JIRA Form] = "Epic" THEN
54*(((6*.5)*([Created count]+[Updated count])/60/60))
ELSE NULL() ENDIF

[MHS]

Got it, thank you very much!