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!
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.