How can we help?

New post
0

SUMIF based on 2 conditions and grouping

Avatar
Bhawish Raj
None
Follow

Please help me out in calculating the sum of "Duration" which is the fourth column. The sum will be calculated for every channel individually. Along with Two other conditions
(@included = "true"),   (@live = "FULL")
As you can see in the below given screenshot. The "Full Screen" time is calculated for only 21 Fixed Channels (C - Column). Channels in column-B keep repeating, but we need to group these channels. and show the result against channels in column C which are a unique list. 

Date Votes

1 comment

  • Avatar
    Parker Selman Official comment

    Hi Bhawish, 

    Thanks for the post! 

    This can be calculated with a GROUPBY formula. See below:

    GROUPBY (@channel , IF ( AND( @included = "true", @live = "FULL" ) , TIME (@duration , "h:mm:ss") , BLANK() )

    This will return a grouped list of durations (in seconds) grouped by channel, with those two conditions applied.  You can then format this in a Klip or model column by formatting it as a duration. 

    I hope this helps! 

    Parker

Please sign in to leave a comment.