Skip to Content
0

Advanced Calculations some don't seem to work

Jan 12, 2017 at 11:35 AM

67

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

Hi Derek - would you be willing to post screen shots of your logic - use the image icon to upload. Also please share version of Analysis Office

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

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

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


ro50r.png (15.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Jan 12, 2017 at 02:02 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 12, 2017 at 02:28 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Jan 12, 2017 at 06:14 PM
0

Derek- I got this to work:


1fussy.jpg (49.3 kB)
Share
10 |10000 characters needed characters left characters exceeded