OK...... I've been racking my brain over this.
I created a search that sum's an amount based on when a purchase order is supposed to ship. The problem is that when I compare it to the month it is not giving me the {item.cost}, I get 0 every time.
Anyone have any idea's what I'm doing wrong?
I have created a generic field to_char({custbody_ship_date},'MONTH') and confirmed that the system is returning the MONTH from the ship date
But when I do the comparison to_char({custbody_ship_date},'MONTH') = 'DECEMBER' I do not get any results, just 0
---------------------------------------------------
Field = Formula (currency)
Summary = Sum
Formula = case when to_char({custbody_ship_date},'MONTH') = 'DECEMBER' then {item.cost} else 0 end