Skip to Content
avatar image
Former Member

Cognos formula rewriting

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 05, 2015 at 09:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded