Hey guys, I know in a saved search I can sum a formula field that uses the CEIL function, but is there any way to CEIL the sum? So if I had 3 results of .1,.1, and .1, it would sum .3 and then CEIL to get 1.

So, I think I found an answer for you on this with a quick google search. It appears someone else has used the CEIL function in a saved search. Example was to see how many days have elapsed since an order was placed, you could do CEIL({trandate}-{today}) which would give you an integer number.

Hi Ricardo, thanks. I know I can use CEIL in the formula and then sum, but that would return 3 from my example as opposed to 1. I'm trying to sum the results first, and then CEIL

if you nest the functions, it would

so don't use the summary type of SUM, and just do the formula as CEIL(SUM(

yeah, summary types get tricky with saved searches. They have their good uses for sure, but I try to stay away from them if I can, as they limit flexibility in a lot of cases.

👍 thank you!

I can't find a way to easily CEIL, but it's definitely possible to round.

Hi Michael, we got this figured out. In a summary search, use AVERAGE, and in the formula use CEIL(SUM(your expression)) and I got the desired result 👍