Is there a built in function to match the ROUNDING functionality used by Cognos within WebFOCUS?

References:
https://www.ibm.com/developerw...00-0000-000014465790

https://www.ibm.com/support/kn...doc/ids_sqs_1480.htm

Thanks, Doug

BTW: I know that We Can Do that In WebFOCUS. But, I don't want to reinvent the wheel.

This message has been edited. Last edited by: FP Mod Chuck,

Both D and P formats automatically round, the difference is what is stored internally. D format keeps all significant digits and displays the rounded result. P displays and stores the rounded result. At least that has been my experience.

Thanks John, I'll check it out, chaning the formats on the fly.

However, the rounding is different in Cognos than in WebFOCUS. WebFOCUS is comparable to Excel, Cognos is not.

I need to duplicate the Cognos functionality. Refer to those two links in my initial post for those details.

~ Thanks, Doug

I guess you could always create a DEFINE FUNCTION to do it.