Cognos formula rewriting

[Former Member]

Dear Experts,

How to write below cognos formula Rewrite  into Crystals, In this BOLD fields are Groups.

total(total(distinct 1 for[RR232_ROUTESEQUENCE_SQL13].[SRV01000].[O_CUS],[TMOD11.CPV56002_COMPANY. C_GL_AU_TYP_2], [TMOD11.CPV56002_COMPANY. N_GL_ACCT_UNT_2], [TMOD11.CPV56002_COMPANY. O_GL_ACCT_UNT_2],[TMOD11.CPV56002_COMPANY. N_GL_ACCT_UNT_1],[TMOD11.CPV56002_COMPANY. O_GL_ACCT_UNT_1],[TMOD11.CPV56002_COMPANY.O_CRP])for [TMOD11.CPV56002_COMPANY. C_GL_AU_TYP_2],[TMOD11.CPV56002_COMPANY. O_GL_ACCT_UNT_2],[TMOD11.CPV56002_COMPANY. N_GL_ACCT_UNT_2],[TMOD11.CPV56002_COMPANY. O_GL_ACCT_UNT_1],[TMOD11.CPV56002_COMPANY.O_CRP])

Thanks & Regards,

M.sateesh.

[former_member11696]

Hi Satish,

Since a lot of people here likely do not know cognos can you explain what the formula does?

Looks as though you are looking for Summaries, maybe?

Don