help on below expression?

[daisy1438]

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

[pradosh_thakur]

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'
)