Hi all... trying to do a "win rate matrix" on clos...
# suiteanalytics
t
Hi all... trying to do a "win rate matrix" on closed proposals via saved search. Months going down the rows, months going across the columns. Getting dollars won is simple enough with this formula: case when ({custbody_dealgrade}='A +' AND (to_char({today},'MM')-to_char({closedate}, 'MM')) = 1 or (to_char({today},'MM')-to_char({closedate}, 'MM')) = -11) THEN {amount} END <--- This gives last month's (always relative to current date) total dollars won. I now need to divide this by total dollars of proposals SENT (which is just {amount} with a summary SUM on it). But how to combine the two? I get an unexpected error every time I try to combine 'em. Any ideas?