Skip to Content
0

Add Advanced Calculations in AFO 2.4.3

Jun 29, 2017 at 02:14 PM

180

avatar image

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

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

2 Answers

Varaprasad Raju Potturi Jun 30, 2017 at 05:52 AM
0

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


screen-dump.png (18.9 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

Yes I am aware of this Raju :-)

0
Tammy Powlas
Jun 30, 2017 at 08:58 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

I have never used "convert to formula" before Tammy. I will look more into this.

0