I'm creating a Summary Level Formula column to divide the result by the number of days in a month. I wanted to make it better (suggestions are welcomed, but I was now trying to do it more simple"). My formula structure that I want to build is this one: IF(CONTAINS(Occupation__c.Date__c, "September"),30,0) But i'm getting this error: Incorrect parameter type for function 'CONTAINS()'. Expected Text, received Object. Anyone knows what might be happening?
Hi @David Sigüenza ,
Use Row-Level Formula Column and Summary-Level Formula Column.
Row-Level Formula Column
CASE(formula3__c.textDate__c,
"January",31,
"February",28,
"March",31,
"April",30,
"May",31,
"June",30,
"July",31,
"August",31,
"September",30,
"October",31,
"November",30,
"December",31,
30)
Summary-Level Formula Column
CDF1:SUM/RowCount
