Skip to Content
avatar image
Former Member

Advanced Calculations some don't seem to work

I'm having problems with advanced calculations too, some of them just don't seem to work, in particular the Boolean ones. No matter what syntax I try I get error messages.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jan 12, 2017 at 01:33 PM

    Hi Tammy

    Thanks for the quick response,SAP AO version is 2.3.1.59737. Error only occurs with Boolean operators, after I posted my question I saw a related post which suggested issue might be HANA SP9 and a bug fixed in SP10. I am not sure whether or not this is the issue here, I don't know what version of HANA we are on but we only recently migrated. I have therefore raised a ticket with our help desk to check this out, but any information you have on advanced calculations would be welcome. Was also trying to add calculations manually in new columns but that seems to be a bit hit and miss too.

    Best regards

    Derek

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 02:02 PM

    Based on your screen shot, I would expect to see some operands with the boolean operator, not just AND

    Advanced calculation has some caveats if you see this thread: https://archive.sap.com/discussions/thread/3852639

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 02:28 PM

    Thanks, I saw that thread too, my issue only seems to happen with Boolean operators. The error message appears as soon as I insert the formula and no matter what I type after inserting it, a few seconds after I finish input the error message reappears. With other formulae it usually adds an opening bracket and a pop-up explanation of the syntax, with the Boolean it doesn't, just the error message.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 06:14 PM

    Derek- I got this to work:

    Add comment
    10|10000 characters needed characters exceeded