
Re: How to calculate Bill type summation?
Alessandro Saccone Apr 3, 2014 4:35 AM (in response to ashok Velisetty )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?
rohit gupta Apr 3, 2014 5:00 AM (in response to Alessandro Saccone )can you please share the sample data
thanks
rohit

Re: Re: How to calculate Bill type summation?
ashok Velisetty Apr 3, 2014 5:13 AM (in response to rohit gupta)you can take below inline table for sample data.
load * inline[
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.

Sample data.xlsx 8.4 K




Re: How to calculate Bill type summation?
Tresesco B Apr 3, 2014 5:10 AM (in response to ashok Velisetty )For Result column, try expression like:
Sum( Total <Billtype> Value)
Assuming you are using straight table.

Re: Re: How to calculate Bill type summation?
ashok Velisetty Apr 3, 2014 5:43 AM (in response to Tresesco B)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?
ashok Velisetty Apr 15, 2014 2:42 AM (in response to Tresesco B)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
sum({1<Monthname={'$(=monthname(admonths(max(date),1)))'},Billtype>}Value)
but it gives overall total not bill type wise.
Thanks,
Ashok.


Re: How to calculate Bill type summation?
Rajamani Vaithiyanathan Apr 3, 2014 5:49 AM (in response to ashok Velisetty )
bill_type_summation.qvw 154.0 K


Re: How to calculate Bill type summation?
NagaArjun Krishnamoorthy Apr 3, 2014 6:04 AM (in response to ashok Velisetty )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

New folder (5).xls 7.0 K

EXE.qvw 153.0 K
