Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Formulas in Webi report

Hi,

Given below should be the webi output:

Emp No, Emp Location, Emp Name, Seniority Date,Curr_Year_Rating,Prev_Year_Annual_Sal_at_April_1st,current Annual_Sal_at_Jan_01

I am using the formulas for these columns: Curr_Year_Rating,Prev_Year_Annual_Sal_at_April_1st,curr_ Annual_Sal_at_Jan_01

Curr_Year_Rating

([Rating] Where(Valid From Date - PK <= January 1st, 2014 AND Valid To Date >= January 1st 2014))

(ii) Prev_Year_Annual_Sal_at_April_1st

([EMPL ADMIN - Salary Yr] Where(Valid From Date - PK <= April 1st, 2013

AND Valid To Date >= April 1st 2013))

(iii)curr_Annual_Sal_at_Jan_01:

([EMPL ADMIN - Salary Yr] Where(Valid From Date - PK <= January 1st, 2014

AND Valid To Date >= January 1st 2014))

Is it ok to use current and previous year formulas for an employee record?

Can I use if  then formula instead of Where clause formulas in the above 3 formulas?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question