expression

[rathnam_qv]

Hi all,

if Scenario=Actual, i need to find total losses

help me,

Thanks in advance

smiley

[tresesco]

Try:

Sum( { <Scenario ={ 'Actual'}>} loss)

Or,

Sum ( If(Scenario=Actual), loss)   

[er_mohit]

Sum(total {$ <Scenario ={ 'Actual'}>} loss)

or

sum( if(Scenario='Actual',total loss))

[rathnam_qv]

and i have Balance and Calculated Balance values. now can u tel me how can i write expression for that

Thanks in advance

smiley

[rathnam_qv]

tel me if it possible with set analysis as well

Thanks

smiley