Help with =IIF[@BatchSize) is Null, expression

The IIF need a condition and then a true and false value so you just have it set to if Batch Size is Null then do the calculation but if it not null you have nothing set.

You are missing the Opening (  before [BatchSize] then at the end you need i believe the following

,[BatchSize])

If you send me the Text of your condition i can fix it.

Thank you dcomerford, here is my test.

=IIF[@BatchSize) is Null, [AMProdItem.QtytoProd] / Ceiling(([AMProdItem.QtytoProd] / [EWPMFormula.FormulaReqQty]))

@mike2665  I dont have your form but this should do it

=IIF([@BatchSize] is Null, [AMProdItem.QtytoProd] / Ceiling([AMProdItem.QtytoProd] / [EWPMFormula.FormulaReqQty]), [@BatchSize])

It worked if I typed in the manual batch size, but it came out blank if I did not enter a manual batch size. If I don’t type in the manual batch size then I want it to perform the standard calculation of;

=[AMProdItem.QtytoProd] / Ceiling([AMProdItem.QtytoProd] / [EWPMFormula.FormulaReqQty])

I’m trying to get an either / or answer. So if the manual batch size is blank it should do the normal calculation, but if you type in a manual batch size in the parameter it will calculate from the manual entry.