Skip to Content
0
Jun 01 at 01:26 AM

IF Statement error

21 Views

I have created a formula and would like to add numbers from that formula if they fit a specific criteria

My Formula is:

@ReqQty = {MIMOMD.reqQty}/((TONUMBER({MIMOMD.MIMOH.ordQty_form}))/{MIMOMD.MIMOH.bomItem,bomRev@MIBOMH>yield})

Then on the 'Select Expert Record' I enter:

if left({MIMOMD.partId},2) = "RM" THEN {@ReqQty} ELSE 0

But receive the error that says "The results of the selection formula must be a Boolean"

Where am I going wrong?