@NS.TX I'd love to take a stab at your formula - but unfortunately, that's one where you really need data to troubleshoot/try it, and a couple hours. The biggest troubleshooting advice I can give you - is NS doesn't like mismatch in summary level within your formula. So if you can figure out how to redo your formula to have the sums at all stages of it, it should be able to be done.

@KevinJ of Kansas How about reviewing this formula that keeps resulting in an 'unexpected error': case when sum({durationdecimal}) <= 44 then (sum({durationdecimal})*({laborcost})) else (sum({durationdecimal})-((sum({durationdecimal})-44)*{laborcost})) end

case when sum({durationdecimal}) <= 44 then sum({durationdecimal}*{laborcost}) else max(sum({durationdecimal}-44)*{laborcost})  end

is my guess

curious - why does the summary type need to be min or max

If you do a sum - it will do that formula for each row of results. So you'll "sum" your "sums" and get bad data

it took the formula, but invalid expression

Try this

case when sum({durationdecimal}) <= 44 then sum({durationdecimal}*{laborcost}) else max(sum({durationdecimal}-44)*max({laborcost}))  end

Fair enough

Like I said at the start - probably a couple hour problem

if i figure out why im getting the invalid expression error, i'll lyk

best bet is to break it out into it's components

@KevinJ of Kansas ty for the assist yesterday, I'm still working on it, but i've made progress, and your insight was integral to that progress