Hi all, I need your help.
I wanted to create an auto-calculation for the value payable in (Co broke payable) column, when [commission status]@row)=” Co-Broke Fee Payable
However, I also want the calculated value to stay reflected in the (Co broke payable) column, even after I have change [commission status]@row)=” No Pending Issue”..”
Below is what I have tried but fail.
=IF(OR([commission status]@row)=”Co Broke Fee Payable”,[commission status]@row)=”No Pending Issue”,[SIN Commission Received]@row*[Co Broke %]@row,0))
Million thanks in advance
