You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Not able to validate if condition with member of SmartList data type when comparing with integer

Accepted answer
edited Oct 27, 2023 5:00AM in Planning 3 comments


I have written very simple formula in free form application, where my cube Hybrid BSO. I have created a dynamic calc member MemberB with member formula mentioned in code snippet. In the formula it references MemberA which is stored member and of data type Smart List. It is assigned with Smartlist YESNO where it has only one entry as YES and it's ID is defined as 1. When I try to validate the formula, I'm getting below error.

An error occurred while validating the member formula.

Error compiling formula for [calc-expression, at or after line: ["IF(MemberA == 1)"]] (line 1): expected type [NUMBER] found [STRING] ([MemberA]) in function [operator @EQ]

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!