Default selection in expression

[dunnalahk123]

Hi,

Can some one help me here

i wrote simple condition as below.in that i want to include WW as default value how can i do that. and again if i select some thing from my filters it should take that value.

example from filters if i select Geogarphy ='APJ' it should give me APJ Values in my report.

Filed name is Global and value is also WW.

num ( SUM ({<ScenarioLabel={'Actuals'}>} NumValue) / SUM ({<ScenarioLabel={'Actuals'}>} DenValue), '0.#%'),

Num( SUM ({<ScenarioLabel={'Actuals'}>} NumValue),'##,###.0'),

Best Regards,

HK

[swuehl]

Maybe like

If( Len(GetCurrentSelections()), //check if there are any selections

Num( SUM ({<ScenarioLabel={'Actuals'}>} NumValue),'##,###.0'), // yes --> consider selections

Num( SUM ({<ScenarioLabel={'Actuals'}, Global = {'WW'}>} NumValue),'##,###.0'), //  no --> use default

)