Help with set analysis expression

agni_gold — Tue, 02 Dec 2014 19:55:12 GMT

I have expression

if([%Link Pump Group]<>[DYN Pump Group Id] and [Pump ID]=[DYN Pump Id] and IsNull([DYN Pump Param Id])=0,[Pump ID])

this expression gives the Pump Ids

I just want to sum the volume for above pump ids .

How to write this expression in set analysis . Please help

Re: Help with set analysis expression

MK_QSL — Wed, 03 Dec 2014 00:01:47 GMT

=SUM({<

[%Link Pump Group] = {"=[%Link Pump Group] <> [DYN Pump Group Id]"},

[Pump ID] = {"=[Pump ID] = [DYN Pump Id]"},

[DYN Pump Param Id] = {'*'}

>}Volume)