sum ( if )

[#1]

Hi

Is there any other calculation for the following expression.

Sum (if (column=' name', if (column=' name', other column)calculation column)).

Thank you.

[SunilChauhan]

i thing this is oppose to requirement SCENARIO = 'JUMP-OFF' comes with  or as per requirement

Sum( If( wildmatch( SCENARIO, 'S*', ) or SCENARIO = 'JUMP-OFF'   RWA ))

hope this helps

[its_anandrjs]

Or may be this helps

=Sum( If( Match( SCENARIO, 'S1') And
          Match( SCENARIO, 'S3') And
          Match( SCENARIO, 'S4') And
          Match( SCENARIO, 'S5') And
          Match( SCENARIO, 'S6') And SCENARIO = 'JUMP-OFF' ,  RWA))

Regards

Anand

[#4]

Hi Anand,

Its not working.

[jagan]

Hi,

Check this expression

=sum({<SCENARIO*={'S1', 'S2', 'S3', 'S4','S5', 'S6', 'JUMP-OFF'}> RWA)

Hope this helps you.

Regards,

Jagan.

[its_anandrjs]

Other wise use or

=Sum( If( Match( SCENARIO, 'S1') And
          Match( SCENARIO, 'S3') And
          Match( SCENARIO, 'S4') And
          Match( SCENARIO, 'S5') And
          Match( SCENARIO, 'S6') Or SCENARIO = 'JUMP-OFF' ,  RWA))

Or please provide any sample file for this will easy to understand the problem with few rows only.

Regards

Anand

[MarcoWedel]

Please post sample data

[#8]

I will post sample data.

Thank you.