Hi,
I have 2 groups :-
GH1 - KPI ID (using only selected KPI ID) & GH2 - KPI Name (Only those names that are assigned to KPI ID)
Need to display MTH / YTD and FY Actual/Target values for each KPI ID based on KPI NAME(GH2) on same line.
eg:- KPI NAME MTH_Actual MTH_Target YTD_Actual YTD_Target FY_Actual FY_Target
X1 xx xx xx xx xx xx
X2 xx xx xx xx xx xx
We will worry only about Actuals for MTH / YTD and FY...
Thus I have 3 formulas -
@YTD Actual -
if {KPI.Period} ="YTD"
then if({KPI.KPI Name} = "X1")
then (ToText ({KPI.Actual},1) & "%")
else if {KPI.KPI Name} = "X2"
then ("$" + ToText({KPI.Actual},1) + "M")
This works Fine and I can see the Values across the row for each KPI Names and the format i choose in Formula.
@MTH Actual -
if {KPI.Period} ="MTH"
then if({KPI.KPI Name} = "X1")
then (ToText ({KPI.Actual},1) & "%")
else if {KPI.KPI Name} = "X2"
then ("$" + ToText({KPI.Actual},1) + "M")
This does not lists me values against each KPI NAMES, it returns blank(NULL).
@FYActual - totext(Sum ({KPI.Forecast}, {KPI.KPI Name}))
This returns correct values as well. However There is a difference between @YTD Actual and this as I have to implement format settings in DISPLAY Properties of the Field and not in the formula. Cause if I do that in formula then it returns Blank (NULL).
All The Formulas and Fields Are Placed In GF2.
Do I need to reset the values for MTH or FY to get the values ? if so then any guidelines on how, I know they needs to be placed as hidden fields on same level.
Just want to display MTH values how can I acheive this ?
cheers
A.B
I have 2 groups :-
GH1 - KPI ID (using only selected KPI ID) & GH2 - KPI Name (Only those names that are assigned to KPI ID)
Need to display MTH / YTD and FY Actual/Target values for each KPI ID based on KPI NAME(GH2) on same line.
eg:- KPI NAME MTH_Actual MTH_Target YTD_Actual YTD_Target FY_Actual FY_Target
X1 xx xx xx xx xx xx
X2 xx xx xx xx xx xx
We will worry only about Actuals for MTH / YTD and FY...
Thus I have 3 formulas -
@YTD Actual -
if {KPI.Period} ="YTD"
then if({KPI.KPI Name} = "X1")
then (ToText ({KPI.Actual},1) & "%")
else if {KPI.KPI Name} = "X2"
then ("$" + ToText({KPI.Actual},1) + "M")
This works Fine and I can see the Values across the row for each KPI Names and the format i choose in Formula.
@MTH Actual -
if {KPI.Period} ="MTH"
then if({KPI.KPI Name} = "X1")
then (ToText ({KPI.Actual},1) & "%")
else if {KPI.KPI Name} = "X2"
then ("$" + ToText({KPI.Actual},1) + "M")
This does not lists me values against each KPI NAMES, it returns blank(NULL).
@FYActual - totext(Sum ({KPI.Forecast}, {KPI.KPI Name}))
This returns correct values as well. However There is a difference between @YTD Actual and this as I have to implement format settings in DISPLAY Properties of the Field and not in the formula. Cause if I do that in formula then it returns Blank (NULL).
All The Formulas and Fields Are Placed In GF2.
Do I need to reset the values for MTH or FY to get the values ? if so then any guidelines on how, I know they needs to be placed as hidden fields on same level.
Just want to display MTH values how can I acheive this ?
cheers
A.B