Is it possible to recreate the SUMIFS formula in DOMO?

RonUrani
RonUrani Member
edited March 2023 in Scheduled Reports

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!

image.png


Answers

  • GrantSmith
    GrantSmith Coach

    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!**

Categories