Skip to Content
0
Dec 18, 2015 at 05:29 AM

Problem with a formula in WEBI

23 Views

Hi All,

I had a problem writing formula in WEBI. Actual formula is in Cognos and it need to be recreated in WEBI. Please find the formula in cognos below and let me know how can I create same in WEBI.

Formula in Cognos :

1) CONVERT(int, CONVERT(float(53), (SUM(field1) - SUM(field2))) / NULLIF((CONVERT(float(53), SUM(field3)) / NULLIF(COUNT(field1), 0)), 0))