Forum Discussion

bjornliow's avatar
bjornliow
New Contributor II
9 months ago

Multiple Or Statements

Hi I am trying to add conditional formatting to my CubeView to bold certain rows, so that it stands out for my users. I'm using treedescendants(i) to list out all the accounts to minimize any maint...
Cube View
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II

Seems to be working for me:  Maybe post a screenshot of your logic.  Could be a typo you're not seeing. Happens to me all the time.

 

 

bjornliow's avatar
bjornliow
New Contributor II
9 months ago

I noticed that if the member description contains a comma, then the formatting would not work. Other descriptions without a comma would work.

Eg: Descriptions:

  1. Apple Fruit
  2. Orange Fruit
  3. Banana, Fruit

Test:

  • If (MemberDescription Contains 'Apple') Or (MemberDescription Contains 'Orange') Or (MemberDescription Contains 'Banana')
    • All bolded 
  • If (MemberDescription Contains 'Apple Fruit') Or (MemberDescription Contains 'Orange Fruit') Or (MemberDescription Contains 'Banana')
    • All bolded
  • If (MemberDescription Contains 'Apple Fruit') Or (MemberDescription Contains 'Orange Fruit') Or (MemberDescription Contains 'Banana, Fruit')
    • None bolded 
  • If (MemberDescription Contains 'Apple') Or (MemberDescription Contains 'Orange') Or (MemberDescription Contains 'Banana, Fruit')
    • None bolded