$(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

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.

Regards

Vaibhav

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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)
    Add comment
    10|10000 characters needed 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

      Vaibhav