@al3xicon - here's the example I was given in my interview, that neither of us could find a solution for: Column B (currency formula) summary type = SUM : case when type = SO then amount else null end Column C ( currency formula) summary type = SUM : case when type = Invoice then amount else null end Column D ( text formula) summary type = ??? : case when SO total > invoice total "You're Fired" else "Good Job" end I don't think that's possible, is it?