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,

The CAQ- custom analytical query have functionality to create restricted and calculated measures on standard CDS view available with and without reporting rules. You could create below restricted measures based on FS items or create this using reporting items and reporting rules:

- Net Income

- Number of shares

After this, you can use above RKFs or Reporting items to create calculated measure to divide Net Income / Number of share to calculate the EPS.

Alternatively, you could create custom CDS view to create this calculation using sql code.

regards,

MJ