Set Analysis

rahulsingh12 — Wed, 22 Nov 2017 05:25:59 GMT

Hi,

I have the following table structure.

State desc volume

AP STW 10

MH STW 20

AP STR 30

MH STR 30

RJ STR 40

I have to write an expression such that in Numerator I have the following condition:

when state ='MH' Then take desc as STW And sum of volume + when other states take STR as desc and then sum of volume.

so the value will be : 30+20+40

and if some one selects just MH the value is 30 alone no calculation for other states.

Regards

Re: Set Analysis

sunny_talwar — Wed, 22 Nov 2017 13:11:14 GMT

May be this

Sum({<State *= {'MH'}, desc *= {'STW'}>+<State -= {'MH'}, desc = {'STR'}>} volume)