[CLOSED] Rounding Cognos VS WebFOCUS

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3697072786

July 19, 2017, 09:55 AM

Doug

[CLOSED] Rounding Cognos VS WebFOCUS

There is a difference in the way that Cognos and WebFOCUS rounds decimal values such as D20.2.

With that in mind, does anyone have a standard way for WebFOCUS to round the same way as Cognos?

Thanks In Advance,
Doug

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

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

July 19, 2017, 10:28 AM

MartinY

Hi Doug,

You've already ask that question and unfortunately, I don't think that the answer to it will be different.

[CLOSED] How to match the ROUNDING functionality used by Cognos within WebFOCUS?

WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007

July 19, 2017, 10:29 AM

Tony A

Hmmmm, You've asked this before Doug, or did you forget?

T
[CLOSED] How to match the ROUNDING functionality used by Cognos within WebFOCUS?

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

July 19, 2017, 10:52 AM

Doug

Yeah... I guess I forgot... and couldn't find it when I searched for "Rounding Cognos VS WebFOCUS".

This message has been edited. Last edited by: Doug,

July 19, 2017, 11:00 AM

Doug

I guess that I shouldn't have closed it as I didn't get much other than using a DEFINE. But, one may want something simpler then adding a DEFINE for every number field in all the reports / sources during a major / critical Cognos to WebFOCUS conversions (Yea!) of 167 reports.