Is it possible to recreate the SUMIFS formula in DOMO?

I have been trying to recreate the SUMIFS formula from excel in DOMO for a while but have had no success. Would something like this be possible? Thanks!


Answers

  • GrantSmith
    GrantSmith Indiana 🥷

    You can use a case statement within your SUM aggregation:

    SUM(CASE WHEN [CONDITION HERE] THEN `Quantity` END)
    
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**