Errors running conditional calculations in survey123

Question

I can't get this to run and i'm out of ideas/time and need to move on.

Any help would be appreciated

Basically 2 calculations, that run according to the unit of measurement selected.

if(selected(${Rate1Units},'oz'),(int(${Product1Rate}*int(${Total_Batches}div128),if(selected(${Rate1Units},'lbs'),int(${Product1Rate}*int(${Total_Batches}))

Capture.PNG

ShawnMcCauley · Answer

i removed the parenthesis after 128 and i think that fixed it.

thanks again Doug

ShawnMcCauley · Answer

Thanks for the help Doug! I'm definitely closer now but it still throws out the "unbalanced brackets/parenthesis error.

dougbrowning · Answer

if(selected(${Rate1Units},'oz'), int(${Product1Rate})*int(${Total_Batches}) div 128), int(${Product1Rate}) * int(${Total_Batches}))

you were missing the ending ) in each int.  Also have no spaces after div.  Finally if it is just 2 possible choices then no need for the second if.

Hope that does it.