If with right nested

Jon_21381
Jon_21381 Altair Community Member
edited February 2021 in Community Q&A
Hello 

Is there any way to get the function to work in data watch

=IF(LEFT(Loan,3)="000",RIGHT(Loan,7),IF(LEFT(Loan,2)="00",RIGHT(Loan,8),0))

Thanks

------------------------------
Jon Pernice

------------------------------
Tagged:

Answers