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

Problem with a formula in WEBI


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))