Hello Group,
In Excel there is a formula called Ceiling that rounds a number up, to the nearest interger or to the nearest multiple of significance. Cognos has a Ceiling function but it only Returns the smallest integer that is greater than or equal to "numeric_expression". So if I have sales of 1, 2, or 3 I would like to round to 4; sales of 5, 6, or 7 round to 8; etc... Any suggestions on how to accomplish this?
Thanks!
BigOCombe
You could use something like a case statement and mod:
case when mod(sales,4) = 0 then sales
else sales + (4-mod(sales,4))
end
Thanks calson, that work perfect.
After thinking about it, you don't even need the case statement. just
sales + (4-mod(sales,4)) will do.