How to change value to 0 with multiple conditions

Question

Hello,

How can i change values to 0 with multiple conditions. i know we can use either Multi Field or Multi Row but not sure how

current output -

Company Serial 2024202520262027202820292030ABC123-00-898642103701244414933179202150425805DEF456-56-7512963155561866722400268803225638707GHI789-21-9019445233332800033600403204838458061EGT321-75-4529167350004200050400604807257687091DGT345-51-244375052500630007560090720108864130637WSR678-32-09656257875094500113400136080163296195956DGT845-10-0998438118125141750170100204121244945293934

expected output - if company is DEF & Serial#456-56-75, company is DGT & Serial#345-51-24 & company is WSR and Serial#678-32-09 then balances for all year should be 0.

Company Serial 2024202520262027202820292030ABC123-00-898642103701244414933179202150425805DEF456-56-75       GHI789-21-9019445233332800033600403204838458061EGT321-75-4529167350004200050400604807257687091DGT345-51-24       WSR678-32-09       DGT845-10-0998438118125141750170100204121244945293934

kauser · Accepted Answer

@griffinwelsh

Thanks for your response but its Multi -field formula not Multi Row formula