Skip to main content
Solved

Formula switch depending on Dimension value

  • May 19, 2026
  • 3 replies
  • 28 views

I have a Transaction List and I want to create a formula that applies logic A when the value in Business Segment Group is value A and uses logic B when Business Segment Group is not value A.

 

 

Thanks for the guidance!

Best answer by Min Li

You can try if(‘IWSR - NRR Data’.’business segment group = Business Segment.”VALUE A”, logic A, Logic B)

3 replies

If statement apparently sufice.


Min Li
Master Helper
Forum|alt.badge.img+14
  • Master Helper
  • Answer
  • May 19, 2026

You can try if(‘IWSR - NRR Data’.’business segment group = Business Segment.”VALUE A”, logic A, Logic B)


Yes that worked!