Zoho Analytics aggregate function breaking specifically with iscurrentmonth function
Hey friends!
I have an aggregate formula Im trying to use that sums a column if iscurrentmonth returns true. Whenever I use this specific function, the formula will somehow return null and show no data in my column. Example below (you'll see Abaraham Ruiz has a blank value in the collections column).
In testing, I can change the function in a myriad of ways and still have my expected result. Whenever I put is_current_month() as a function in the aggregate formula behind a sum_if function, it blanks out one of the users. I'm thinking this is a bug?
Note: I have specifically tried including = 1 or = 0 after the is_current_month in case that was throwing errors, but I ended up with the same result.
I have an aggregate formula Im trying to use that sums a column if iscurrentmonth returns true. Whenever I use this specific function, the formula will somehow return null and show no data in my column. Example below (you'll see Abaraham Ruiz has a blank value in the collections column).
In testing, I can change the function in a myriad of ways and still have my expected result. Whenever I put is_current_month() as a function in the aggregate formula behind a sum_if function, it blanks out one of the users. I'm thinking this is a bug?
Note: I have specifically tried including = 1 or = 0 after the is_current_month in case that was throwing errors, but I ended up with the same result.
Function:
sum_if("OB Leadership Dashboard SQL"."Added Collections End Date" >= next_nmonth(start_day(month,today()),1),"OB Leadership Dashboard SQL"."Amount Collected MTD")+sum_if(is_current_month("OB Leadership Dashboard SQL"."Added Collections End Date") = 1,"OB Leadership Dashboard SQL"."Amount Collected MTD")
Screenshot of blank result:
