Encountered an error when i used this in the result tab of saved search column : Formula(numeric) Summary Type: Maximum Formula: sum({custrecord161})-{custrecord154.shippingcost}

It looks like you are telling it to use 2 different summary types at the same time. I haven't tried that myself so I don't know if that is what is giving you the error. Do you have any other results that work that designed in a similar way? Is something preventing you from doing this: Column : Formula(numeric) Summary Type: Sum Formula: {custrecord161}-{custrecord154.shippingcost} That would probably cause field 154 to apply multiple times which is not what you want, right?

I think the combo of Maximum and Sum is fine, but I'm thinking it doesn't like that you're only summing part of your formula. I think when you're doing that kind of summary combination, it's all or nothing in the formula. So you'd have to do either sum({custrecord161}-{custrecord154.shippingcost}) or sum({custrecord161})-sum({custrecord154.shippingcost}). First option I'm fairly sure would work. 2nd one I'm not as confident in. I'd also double-check that both 161 and 154 are the same type and that they're both numeric. I think it throws unexpected error on type mismatches sometime too.