Earnings per Share in GR

[g11600]

Hi gurus

We have a business requirement to calculated earnings per share (EPS) and show in a number of reports, queries, extracts etc. EPS is the operating income (which is defined as reporting item and/or hierarchy node) divided by number of shares (which will be statistical FS item). Ideally - EPS will be automatically updated to reflect current operating income after any JE etc.

We have looked at options to calculate this in Excel based on AFO or in SAC - but neither option is acceptable as this is key account which needs to be reused in a lot of different places and dashboards. Also custom query seems complex (if feasible at all) as this is effectively a new account/reporting item, not measure.

Do you have any suggestions on how to meet this requirement in GR?

Thanks very much

[manish_jain7]

Hi Jonathan,

Can you use CAQ calculated measure option which can be exposed in AFO workbook or SAC query for dashboarding purpose? If it needs to be stored in database, you could convert AFO workbook in journal upload template to load or manually post one sided journal against statistical item for EPS.

Regards,

MJ

[g11600]

Thanks, this sounds like a good option. Can you clarify what you mean by 'CAQ calculated measure'? I'm not familiar with that, only standard calculated measures in CDS view. I this case we really need a virtual account (like reporting rules) without reference to different deimensions such as profit center, cost center, CU etc.