HI Team,
I am trying to create a formula field to calculate value based on picklist and other field.
Pick List Fields are: Month, Week & Day
Hours: Number Field
Formula Field: I want to achieve if I choose Month it should calculate 30 x Hours, If I choose Week it should calculate 7 x Hours and If I choose Day it should calculate 1 x Hours.
My formula is
If(Contains(${Products.UoM},'Month'),30,If(Contains(${Products.UoM},'Week'),7,IfContains(${Products.UoM},'Day'),1,1)))
*${Products.Daily Hours}
its not working