Hi ,
Thank You.
it works in that way, but again format changes ,
bec in that $(vLESQBRNEW) i have wrote multiple flags like metrics with flag 1 contains all percentage metrics , metrics with flag 2 contains numerical number and so on.
so is it some thing we can add to below expression directly. same below expression is nothing but $(vLESQBRNEW) this variable same you can get it from app in variable Section.
instead of writing below as format changes ,, can we add to variable expression directly ?
$(vLESQBRNEW)
+
(SUM ({1<ScenarioLabel={'Actuals'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue)*0)
Expression :
IF ( MAX( {$<FY_QM={'Threshold'},Scope={'LES'}, QBR={'Primary (QBR)'},FYear={'Threshold'},FY_MonthName={'Threshold'},WW=,Region=, Geography=, SubGeo1=, SubGeo2=, Country=,QuarterID=>} TargetFlag) = 1,
IF( MIN({$<FY_QM={'Threshold'},Scope={'LES'},QBR={'Primary (QBR)'},WW=,Region=, Geography=, SubGeo1=, SubGeo2=, Country=,Area=,Region_memberid_label={$(vUnqGeography)},QBR=,Month=,FY_Month=,FY_QM=,FY_Quarter=,FYear=,QuarterID=>} NumValue)=0,'Dir',
MAXSTRING({$<FY_QM={'Threshold'},Scope={'LES'},QBR={'Primary (QBR)'},WW=,Region=, Geography=, SubGeo1=, SubGeo2=, Country=,Area=,
Region_memberid_label={$(vUnqGeography)},Month=,FY_Month=,FY_QM=,FY_Quarter=,FYear=,QuarterID=>} NumValue) ),
If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'LES'}>} LESMetric_Flag ) = 1,
IF(GetFieldSelections(Geography)>0 OR GetFieldSelections(SubGeo1)>0 OR GetFieldSelections(SubGeo2)>0 OR GetFieldSelections(Country)>0 OR GetFieldSelections(Area)>0 ,
num ( SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue) /
SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} DenValue), '0.#%'),
num ( SUM ({<ScenarioLabel={'Actuals'},WW={'WW'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue) /
SUM ({<ScenarioLabel={'Actuals'},WW={'WW'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} DenValue), '0.#%')
),
If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'LES'}>} LESMetric_Flag ) = 2,
IF(GetFieldSelections(Geography)>0 OR GetFieldSelections(SubGeo1)>0 OR GetFieldSelections(SubGeo2)>0 OR GetFieldSelections(Country)>0 OR GetFieldSelections(Area)>0 ,
num ( SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue),'##,###.0'),
num ( SUM ({<ScenarioLabel={'Actuals'},WW={'WW'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue),'##,###.0')
),
If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'LES'}>} LESMetric_Flag ) = 3,
//IF(WW='WW',num ( SUM ({<ScenarioLabel={'Actuals'},Quarter={$(vFYQ_5Final)},Scope={'LES'}>} NumValue),'#,##0' ),
num ( SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue),'#,##0' ),
If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'LES'}>} LESMetric_Flag ) = 4,
num ( FABS(SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},SubMetric={'COD'},Metric={'CoD as % Revenue -'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue)) /
FABS(SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},SubMetric={'Rev'},Metric={'CoD as % Revenue -'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue))
, '0.#%;0.#%'),
If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'LES'}>} LESMetric_Flag ) = 5,
IF(GetFieldSelections(Geography)>0 OR GetFieldSelections(SubGeo1)>0 OR GetFieldSelections(SubGeo2)>0 OR GetFieldSelections(Country)>0 OR GetFieldSelections(Area)>0 ,
SUM ({<ScenarioLabel={'Actuals'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue) ,
SUM ({<ScenarioLabel={'Actuals'},WW={'WW'},Scope={'LES'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>} NumValue)
),
If ( MAX ( {<ScenarioLabel={'Actuals'},Scope={'LES'}>} LESMetric_Flag ) = 6,
IF(GetFieldSelections(Geography)>0 OR GetFieldSelections(SubGeo1)>0 OR GetFieldSelections(SubGeo2)>0 OR GetFieldSelections(Country)>0 OR GetFieldSelections(Area)>0 ,
//Num(Avg(Aggr(Avg({$<Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>}[E2E Deployment TAT]), [E2ETATPROJECTID])),'#,##0' ),
Num(Avg({$<Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>}[NumValue]),'#,##0' ) ,
Num(Avg({$<WW={'WW'},Month={">=$(vMinMonth) <=$(vGetMaxQuarterMonthFinal)"}>}[NumValue]),'#,##0' )
),
)))))
)
)
