Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Member formula not working in Hybrid BSO — Cloud Customer Connect
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

Member formula not working in Hybrid BSO

Accepted answer
112
Views
13
Comments
in Planning 13 comments

Summary:

Member formula working well in traditional BSO, but not working in Hybrid BSO.

Content (required):

Hi ,

We have a pretty simple member formula for an account member, which works without issues with traditional BSO, but when replicating the same in Hybrid BSO it doesn't work. The formula is as simple as below:

IF(@ISMBR("Jan"))

1;

ELSEIF(@ISMBR("Feb"));

2;

.........

ELSEIF(@ISMBR("Dec"));

12;

The weird thing is that the formula only shows results for Jan, and not showing results for Feb~Dec. Also, the formula only shows results for a certain number of rows(e.g. if I have 20 rows with different sparse member combinations, it only shows results for a few of the rows and the rest of rows has no results). It would be expected that the formula should show the correct results for Jan~Dec with any combinations as it's dynamic calc. This makes no sense and I cannot think of a reason why it's not working.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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