How to summarize attributes through a read-only report or a cda-report in Financial Management FM5.5

Brian_Hansen — Thu, 13 Feb 2020 09:13:41 GMT

Hi, I have a FM 5.5 installation, where we use a lot of attributes on f.ex. employee name, accounts etc. and I am looking for a way to summarize and show the sum for certain attributes in the reporting (read-only or CDA in Excel).

It is quite easy to limit the report til certain attributes, but you loose the sums in the other dimensions doing so.

I have attached a read-only report (where I am missing a sum for the acccount (1. dimension in rows).

I have tried using calculated members in Excel and cda, In Studio I have tried to use formulas, but no luck so far.

PS: Not certain about which board to choose (haven't found one specific for FM), so please help if you have the name of a better board for this question.

bye

Brian

Re: How to summarize attributes through a read-only report or a cda-report in Financial Management F

ElizabethKyria — Tue, 25 Feb 2020 14:57:45 GMT

Hi Brian,

Please open a tech support track to assist with your question below, see link here - https://support.sas.com/en/technical-support/contact-sas.html

Kind regards

Liz

Elizabeth Kyriacou

Business Operation Specialist

Fraud & Security Intelligence Division

Tel: + 44 (0)1628 490859 ▪ Mobile: + +44 (774) 1241863▪ elizabeth.kyriacou@sas.com

SAS ▪ 7^th Floor 199 Bishopsgate ▪ London, EC2M 3TY

www.sas.com/fraudfinancialcrime

SAS® … THE POWER TO KNOW®

topic Re: How to summarize attributes through a read-only report or a cda-report in Financial Management F in Fraud, AML and Security Intelligence

How to summarize attributes through a read-only report or a cda-report in Financial Management FM5.5

Re: How to summarize attributes through a read-only report or a cda-report in Financial Management F