function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AndyuxAndyux 

formula COUNTER with condition

I have a custom field "Hot Dogs Count Q1-2017" (rollup sumary for related MC custom object "Hot Dogs") in Account object. Field is duplicated for 8 Quarters (Hot Dogs Count Q2-2017, Q3 etc)
I need to count the number of accounts where "Hot Dogs Count" is greater than 0, per Quarter.
I  used the roll up count to include criteria for the related object records count.

2017Q1 Counter
if "Hot Dogs Count Q1-2017" > 0 then +1
(Adds 1 for every account where the condition is true)

Trigger? is there not a way to build a counter in a formula? thanks
AndyuxAndyux
something like this 
(Total_cases_Q1_2017__c > 0), Counter_accts_Q12017__c + 1