cancel
Showing results for 
Search instead for 
Did you mean: 

Earnings per Share in GR

g11600
Explorer
0 Kudos
196

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

Accepted Solutions (0)

Answers (2)

Answers (2)

manish_jain7
Active Participant
0 Kudos

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

manish_jain7
Active Participant
0 Kudos

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
Explorer
0 Kudos

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.