Skip to Content
Author's profile photo Former Member

IF..ELSE..THEN functions in BEX

                                                                      IF..ELSE..THEN functions in BEX

  •     For suppose, the query has if, else and then functions

IF_Else_Image.PNG

Limitations:

  • There is no specific function for IF.
  • If we specify Condition like *0 + 1 then the condition will wont work.

Thanks & Regards

Trinadh Kumar Reddy B

Senior Software Engineer

iGATE GLOBAL SOLUTIONS

Assigned tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sherif Elkoumi
      Sherif Elkoumi

      if condition one less that condition two multiply by 1 otherwise show zero

      ??is that understanding correct

      sherif

      Author's profile photo Former Member
      Former Member

      Actually in our case we maintain intially then 0 else 1 but its not populating data in report output.

      When i changed to then 1 else 0...then the condition is woking.....I though that would be the BW Bex Limitation...I have developed like that 40 Queries....Same Output is reflecting...

      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      For a document, you could have put some more effort in showing some result screens.

      Are you sure this would work. Because I think a BEx condition like thiss would return a value '1' IF TRUE and would return '0' IF FALSE.

      So as per your formula if GROSS < BASE the result would be '1' (1*1+ 0 )

      Author's profile photo Former Member
      Former Member

      Actually in our case we maintain intially then 0 else 1 but its not populating data in report output.

      When i changed to then 1 else 0...then the condition is woking.....I though that would be the BW Bex Limitation...I have developed like that 40 Queries....Same Output is reflecting...

      Author's profile photo John K
      John K

      Hi Reddy,

      Whenever you post any document that should have the clear explanation and proper solution. I Think it's your first post, don't shame to post again try to keep the following tips for your upcoming post.

      The people will get know something form your post.

      Every post for fresher's and unknown person's not for known think this in you mind.

      Even you are posting basic try to explain with real time example.

      Regards,

      John.

      Author's profile photo Former Member
      Former Member

      I have posted exact scene of the scenario....from next time onwards i will try to elabrate the Scanario and then i will post the document.

      Thanks for giving your valuble feedback.

      Regards

      Trinadh Reddy B.

      Author's profile photo B. Struijk
      B. Struijk

      Very nice explanation
      The syntax is very not intuitive, but your picture makes it very clear in a simple way.

      Thank you very much.