Hello there, i've begun to build a saved search to measure Sales metrics within the year, (beginning with Won/Lost and Open Opps), and i'm having issues pulling the correct totals for some Sales reps, i suspect that this may be because the figures are being inflated by quote totals being included in the Opp projected total, possibly because i'm using Quote/Opportunity status within formulas, as i can't use straight Opportunity status, this is mirrored in the fact that we use the Quote option on Netsuite only sparingly and it's their figures that appear to be inflated. When i print an Excel of the inflated results i'm finding that the figures for Open Opps differ from those in the report so may be i'm just using a formula that is correct in some cases but not in others, below are the criteria and columns used, all others are working well, apart from the on highlighted in red, would be grateful for any advice as to how i can ensure that only Opportunity projected total is pulled into the results, or if anyone has advice on how this can be improved, thanks for your help.