Hello,
I have a data set looks like below (pls see the first table). is it possible to write something using formula and get me to the result ( pls see the second table). Thank you!
Name | item A | item_b | ITEM C |
ABC_123 | 0 | 999 | 0 |
DEF_456 | 0 | 0 | 666 |
GHI_789 | 888 | 777 | 0 |
Result
GHI_789 | 888 | 777 | 0 |
Hi @Emma_c_857
Here is how you can do it.
Workflow:
Hope this meets your requirement.
Hope this helps : )
Hi @Emma_c_857 ,
Like @atcodedog05 I'm not sure of the logic, but just assuming you want to remove records where the second column is zero then you can do the following:
A simple filter tool removing those records gives the following:
I've attached the workflow. If this is not the required logic can you let us know?
Hope this helps,
M.
Hello,
yes, that was the correct logic. Thank you!
Thank you!
Happy to help : ) @Emma_c_857
If the response helps please don't forget to mark it as solution.
Cheers and have a nice day!