How to transform from Excel Sumif formula to Domo ?
Hi, I have a data report with a template that looks like this in Excel:
And I need to transform this into a card.
So far I managed to make beast mode like this:
Sum( CASE WHEN CONCAT( product_code, "_", account_id,
account_name) = account
THEN Value ELSE 0 END)
But how do I take into account that the value for the Product Code is not fixed? And also, is making a card that looks like this template possible in Domo? Thanks a lot!