Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
ex:I am using below expression for total value.
Pick(Match($(vKPI),'RS_ESLLMI','RS_TRIFCE','RS_THRCP','RS_EFMCPSF','RS_EFMCPE','RS_CQRO','RS_CEHSSRO',
'RS_QSCAPAG','RS_CAPAT','RS_QSNC','RS_TC','RS_SHWRC','RS_FCA','RS_BI'),
If($(vSiteCountRS_ESLLMI)=0,Null(),$(vCurrentRS_ESLLMI)),
If($(vSiteCountRS_TRIFCE)=0,Null(),$(vCurrentRS_TRIFCE)),
If($(vSiteCountRS_THRCP)=0,Null(),$(vCurrentRS_THRCP)),
If($(vSiteCountRS_EFMCPSF)=0,Null(),$(vCurrentRS_EFMCPSF)),
If($(vSiteCountRS_EFMCPE)=0,Null(),$(vCurrentRS_EFMCPE)),
If($(vSiteCountRS_CQRO)=0,Null(),$(vCurrentRS_CQRO)),
If($(vSiteCountRS_CEHSSRO)=0,Null(),$(vCurrentRS_CEHSSRO)),
If($(vSiteCountRS_QSCAPAG)=0,Null(),$(vCurrentRS_QSCAPAG)),
If($(vSiteCountRS_CAPAT)=0,Null(),$(vCurrentRS_CAPAT)),
If($(vSiteCountRS_QSNC)=0,Null(),$(vCurrentRS_QSNC)),
If($(vSiteCountRS_TC)=0,Null(),$(vCurrentRS_TC)),
If($(vSiteCountRS_SHWRC)=0,Null(),$(vCurrentRS_SHWRC)),
If($(vSiteCountRS_FCA)=0,Null(),$(vCurrentRS_FCA)),
If($(vSiteCountRS_BI)=0,Null(),$(vCurrentRS_BI))
)
present i want region wise total value.
if region=north america than calculate the above expression.
how to include the region filter condition in to above expression.
Thanks
if(region='north america', Pick(Match($(vKPI),'RS_ESLLMI','RS_TRIFCE','RS_THRCP','RS_EFMCPSF','RS_EFMCPE','RS_CQRO','RS_CEHSSRO', 'RS_QSCAPAG','RS_CAPAT','RS_QSNC','RS_TC','RS_SHWRC','RS_FCA','RS_BI'), If($(vSiteCountRS_ESLLMI)=0,Null(),$(vCurrentRS_ESLLMI)), If($(vSiteCountRS_TRIFCE)=0,Null(),$(vCurrentRS_TRIFCE)), If($(vSiteCountRS_THRCP)=0,Null(),$(vCurrentRS_THRCP)), If($(vSiteCountRS_EFMCPSF)=0,Null(),$(vCurrentRS_EFMCPSF)), If($(vSiteCountRS_EFMCPE)=0,Null(),$(vCurrentRS_EFMCPE)), If($(vSiteCountRS_CQRO)=0,Null(),$(vCurrentRS_CQRO)), If($(vSiteCountRS_CEHSSRO)=0,Null(),$(vCurrentRS_CEHSSRO)), If($(vSiteCountRS_QSCAPAG)=0,Null(),$(vCurrentRS_QSCAPAG)), If($(vSiteCountRS_CAPAT)=0,Null(),$(vCurrentRS_CAPAT)), If($(vSiteCountRS_QSNC)=0,Null(),$(vCurrentRS_QSNC)), If($(vSiteCountRS_TC)=0,Null(),$(vCurrentRS_TC)), If($(vSiteCountRS_SHWRC)=0,Null(),$(vCurrentRS_SHWRC)), If($(vSiteCountRS_FCA)=0,Null(),$(vCurrentRS_FCA)), If($(vSiteCountRS_BI)=0,Null(),$(vCurrentRS_BI)) ) ,'your_else_expression' )