IF Statement error

[akoglu]

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?

[OwenLiu]

Welcome and thanks for visiting SAP Community to get answers to your questions. While you're waiting for help, check out our tutorial to get started in SAP Community: https://developers.sap.com/tutorials/community-start.html, as it provides tips for preparing questions that draw responses from our members. The more details you provide, the more likely it is that members will be able to help you. Should you wish, you can revise your question by selecting Actions, then Edit. By adding a picture to your profile you encourage readers to respond to your question. Learn more about your profile here: https://developers.sap.com/tutorials/community-profile.html