Forum Discussion
ChuckGrigsby
7 years agoQrew Cadet
Try a case statement
Case(true,
[Broker 1 Name]="ABC",[Commission 1],
[Broker 2 Name]="ABC",[Commission 2],
[Broker 3 Name]="ABC",[Commission 3],
"")
Case(true,
[Broker 1 Name]="ABC",[Commission 1],
[Broker 2 Name]="ABC",[Commission 2],
[Broker 3 Name]="ABC",[Commission 3],
"")