if(contains(prop("Project"), "Work") and contains(prop("Client"), "Wag"), prop("WC"), toNumber(""))
<aside>
💡 contains
was used above so that the total appears even if Work or Wag are not the only tags in their respective properties. If there is only ever going to be one Project and Client for a project then you can change those properties to regular selects and use the slightly shorter equal
version for Totals below.
</aside>
if(prop("Project") == "Work" and prop("Client") == "Wag", prop("WC"), toNumber(""))
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>