Problem with a formula in WEBI

[Former Member]

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

[Former Member]

Hi,

first of all you need to explain us what exactly your formula does.

Regards,

Rogerio