Rolling Sum

[#1]

Hi Guys

I have two tables in following manner

Table1: There is a list box in my UI where i can select the project name

ProjId   ProjName ReportId

1           test         10

1           test         11

1           test         12

1           test         13

1           test         14

Table2:

ReportId State Mode Ecomments

10           1      Y          2

11           2      Y          5

12           1      N          7

13           2      Y          9

14           2      N          1

My requirement is like when i select project test in UI then

I want to display the sum of all 'Ecomments' which satisfying the folllowing condition State=2 AND Mode=Y in a text box

Please help me

Tribhuwan

[Anonymous]

You could use something like this:

Sum({$<State={2}, Mode={'Y'}>} Ecomments)

[#3]

Actually this is a sample one and I have to check for lot of constraints for a report id. Is there any way if we can do like

If( cond1 AND

Cond2 AND …….

Ecomments)

Thanks & Regards

Tribhuwan

[#4]

When I try like this

Sum( If( cond1

AND cond2

AND cond3………..

,Ecomments,0)

)

The result get multiplied by 6 I have no idea why this is happening.

Thanks & Regards

Tribhuwan

[#5]

Hi Johannes

Can you please help me why the sum is being multiplied by a fix costant.

Thanks & Regards

Tribhuwan