$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content

HANA studio If Else Scenario

Jan 25, 2017 at 06:49 AM


avatar image

Hi All,

i am applying a logic like:

if("Material"='xxx' or "Material"='yyy' and ("Type"='261' or "Type"='262'), "Qty",0)

In the above case i want to display Quantity if Either of the Material and Either of the Type is true. Both of the conditions before and after AND must satisfy.

But the result i am getting is considering only Material even if the Type is different, for eg

Material Type Qty (Wrong)

xxx 101 5000

Material Type Qty (Correct)

xxx 262 1000

Please help me if i am missing something.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Jan 25, 2017 at 07:00 AM

I think you have to enclose the Material conditions also in brakes, otherwise if the Material is 'xxx' the further conditions are not considered anymore. At the moment the Type conditions are only applied in case the Material is 'yyy'.

if(("Material"='xxx' or "Material"='yyy') and ("Type"='261' or "Type"='262'), "Qty",0)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Florian,

Got the solution for the above scenario the same way you suggested.

if(("Material"='xxx' or "Material"='yyy') and ("Type"='261' or "Type"='262'), "Qty",0)

Thanks and Regards