8 Replies Latest reply: Apr 15, 2014 2:42 AM by ashok Velisetty

# How to calculate Bill type summation?

Hi ,

I have data like below

 Date Billtype Queue LOB Value 4/1/2014 UB DE A 10 4/1/2014 B 20 4/1/2014 VER C 30 4/1/2014 HCFA DE A 1 4/1/2014 B 2 4/1/2014 C 3

i need result like below

 Dae Billtype Queue LOB Value Result 4/1/2014 UB DE A 10 60 4/1/2014 B 20 60 4/1/2014 VER C 30 60 4/1/2014 HCFA DE A 1 6 4/1/2014 B 2 6 4/1/2014 C 3 6
• ###### Re: How to calculate Bill type summation?

But what is the logic to sum values to obtain result?

Data is the same and other fields are not present in all records.

How to aggregate Result?

• ###### Re: How to calculate Bill type summation?

can you please share the sample data

thanks

rohit

• ###### Re: Re: How to calculate Bill type summation?

you can take below inline table for sample data.

 Date Billtype Queue LOB Value 4/1/2014 UB DE A 10 4/1/2014 B 20 4/1/2014 VER C 30 4/1/2014 HCFA DE A 1 4/1/2014 B 2 4/1/2014 C 3

];

otherwise you can below attachment.

Thanks,

Ashok.

• ###### Re: How to calculate Bill type summation?

For Result column, try expression like:

Sum( Total <Billtype> Value)

Assuming you are using straight table.

• ###### Re: Re: How to calculate Bill type summation?

Thanks yar it working fine but little change only.

sum(Total<Billtype,Date>Value).

Thank u very much it helped alot.

Thanks,

Ashok.

• ###### Re: How to calculate Bill type summation?

Hi Tresesco,

I have one more question ,i need same result format as like above but i need previous month bill type total.

i am using below expression

but it gives overall total not bill type wise.

Thanks,

Ashok.

• ###### Re: How to calculate Bill type summation?

Hi,

Please find the attached QVW.

The end result of the chart is

• ###### Re: How to calculate Bill type summation?

Use This Expression Very Helpful For U

(=aggr(NODISTINCT Sum(Value),Billtype))

And

Lets Pls Find The Attachment It's Very Much Helpful For U..!

Regards By

ArjunKrish