IF..ELSE..THEN functions in BEX
IF..ELSE..THEN functions in BEX
- For suppose, the query has if, else and then functions
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
if condition one less that condition two multiply by 1 otherwise show zero
??is that understanding correct
sherif
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...
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 )
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...
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.
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.
Very nice explanation
The syntax is very not intuitive, but your picture makes it very clear in a simple way.
Thank you very much.