Getting wrong result in Straight table

[bhupesh_gupta]

Hi All

I have one scenario which I am not able to implement.

Data is some thing like this

!

Policy	UWR	Group	Amount
100	1	111	2000
100	2	111	3000
100	3	112	5000
200	4	111	1000
200	1	111	1750
200	5	112	3000
300	5	112	6000

So here a policy can have multiple Group and amount divided between them.

Now if a user selects one group in a list box let's say 112, resultant table should show some thing like this

Policy	Group	Paid to 112	total Policy Amount
		14000	21750
100	112	5000	10000
200	112	3000	5750
300	112	6000	6000

But I am getting this

Policy	Group	sum(Amount)	=sum({<Policy=p(Policy),Group=>}Amount)
		14000	21750
100	111	0	5000
100	112	5000	5000
200	111	0	2750
200	112	3000	3000
300	112	6000	6000

Can some one help me on this.

I have attached the sample app as well.

Regards

Bhupesh

[rubenmarin · Accepted solution]

Hi Bupesh, maybe with:

=If(not IsNull(Group), sum(TOTAL <Policy> {<Policy=p(Policy),Group>}Amount))

If(not IsNull(Group) --> To show only rows of the selected groups.

TOTAL <Policy> --> To sum all groups amount of the same policy

[lironbaram]

hi

have a look at the attachment

[bhupesh_gupta]

Hi Liron

Thanks your option works as well

Regards

Bhupesh

[bhupesh_gupta]

HI Ruben

Thanks it worked.

Regards

Bhupesh

[rubenmarin]

Glad to help.

The "Policy=p(Policy)" is not needed, as the selections will do that, so:

=If(not IsNull(Group), sum(TOTAL <Policy> {<Group>}Amount))