You need to sign in to do that
Don't have an account?
Andyux
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
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
Andyux
something like this