Skip to Content

Add Advanced Calculations in AFO 2.4.3

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 30, 2017 at 05:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Yes I am aware of this Raju :-)

  • Jun 30, 2017 at 08:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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