Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
My question is maybe that difficult but I doesn't find any good solution.
I have a calculation like this:
sum(aggr((sum({<Salary_Type_ID={'020'}>} Num_Hours_Def))
*(Max({$<KPI_Heading={"Contracted Hours Per FTE"}, KPI_RowDesc={"Draketimmar"}>} KPI_Value)))
/
if(Staff_Category_ID='Staff', (Max({$<KPI_Heading={"Contracted Hours Per FTE"}, KPI_RowDesc={"SPX"}>} KPI_Value)),
(Max({$<KPI_Heading={"Contracted Hours Per FTE"}, KPI_RowDesc={"Draketimmar"}>} KPI_Value)))))),Business_Group_ID ,Business_Unit_ID, Staff_Category_ID, Agreement_ID, Booking_month))
On the second calculation (the if statement) I would like to compare with the previous month.
Thanks in advance
I will try to make it more clear.
First expression: jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec
Second expression: feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec, jan
Any one that have a godd solution for this?
hello,
Please attach sample qvw
See attached qvw.