Adding Conditions

[#1]

Hello,

I was wondering if anyone could help with an issue im currently facing.

I need to add totals of ammount depeding on the guy that registred it.

For example, my data base looks like this.

Buyer	Ammount	DailyBudget	Item Code
B1	5	25	201
B1	12	35	202
B1	23	25	201
B2	34	35	203
B2	7	25	201
B3	8	25	201
B3	34	35	203
B3	21	35	202
B3	11	35	202
B1	5	35	203

The tricky part is when i have to compare it to the daily budget.

Every buyer has his daily budget, sometimes is the same between different items and sometimes it isnt. I need a result kinda like this:

Buyer	Ammount	Daily Budget
B1	43	95
B2	41	60
B3	74	95

The daily budget for each one is the sum the daily budget of every different item code you have.

thanks for the help,

KR

[Anonymous]

Use a a straight table with :

Dimension:

     Buyer

Expressions :

     sum([Ammount])

     sum([Daily Budget])

[sunny_talwar · Accepted solution]

Try this expression for Daily Budget:

=Sum(Aggr(Avg(DailyBudget), [Item Code], Buyer))

[#4]

thanks, worked great

[sunny_talwar]

Awesome