cancel
Showing results for 
Search instead for 
Did you mean: 

YTD Salary calculation in data action

sivapuram_phanikumar
Active Participant
0 Kudos

Hello Team - I would like to do a YTD calculation for salary in data actions advanced formula step. Can you please let  me know how I can implement this?

SAP Analytics Cloud 

Thanks,

Phani

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@sivapuram_phanikumar 

Please provide a little more details, some example of what you need to calculate, some information of the model. Else its too generic to respond.

 

Nikhil

sivapuram_phanikumar
Active Participant
0 Kudos

Hello @N1kh1l - Sorry for being too generic. I'll try to elaborate it. I have a requirement in Labor Model where I need to calculate YTD salary of an employee, which would further be used in another calculation. Please find below an example of what I am looking for.

Data in the model:

Emp. NameDataSourceGLAccountJanFebMarchAprMayJuneJuly...
XYZEMP_SALARYSALARY$ 1000$ 1100$ 990$ 1050$ 1000$ 900$ 975

Expected output within Data Action

Emp. NameDataSourceGLAccountJanFebMarchAprMayJuneJuly...
XYZEMP_YTD_SALARYSALARY$ 1000$ 2100$ 3090$ 4140$ 5140$ 6040$ 7015

I tried to create calculated measures at model level. I have two challenges here - 1. I cannot use the calculated measure in the model and 2. I used ITERATE and PRIOR functions. But could not achieve what I am looking for.

So, any help to achieve this at data action level and subsequently use it for further calculation would be really helpful.


Thanks,
Phani