Hi AFO folks - I am looking for some examples of logic for the advanced calculations option in AFO. I want to do IF, THEN, ELSE, <, >, type stuff. Any help will be appreciated.
Here's me getting no where fast:
The reason why I am trying this is because adding new columns and inserting my own Excel formulas is making this report open up in 10 minutes w/Excel formulas, instead of 10 seconds wo/Excel formulas.
Kind regards,
Kelly
Hi,
It seems Boolean Operators ( >, <, >=, <= and <>) are missing in AO.
Please find below comparison between BW Bex Query designer vs AO.
In Bex also we do not have IF and Else , but using these Boolean Operators we can define If else conditions.
Thanks,
Raju
Yes I am aware of this Raju :-)
Kelly - I wonder if "convert to formula" would help? See https://archive.sap.com/discussions/thread/3280383 - I'll try some other things as well.
I have never used "convert to formula" before Tammy. I will look more into this.