This content has been marked as final.
Show 10 replies
-
Re: Sum, aggr and total
Anil Babu Sep 7, 2016 11:24 AM (in response to Juan Patricio Iorio)What is the expected O/P from given table
-
Re: Sum, aggr and total
Juan Patricio Iorio Sep 7, 2016 11:26 AM (in response to Anil Babu )TYPE TOTAL TRX
1 7
2 0
3 0
-
-
Re: Sum, aggr and total
Andrew Walker Sep 7, 2016 11:42 AM (in response to Juan Patricio Iorio)Hi Juan,
Have you tried
Sum(TOTAL <type> transactions) ?
EDIT :Sum({$<type2 = {'1*'}>}TOTAL <type> transactions)
Kind regards
Andrew
-
Re: Sum, aggr and total
Juan Patricio Iorio Sep 7, 2016 11:41 AM (in response to Andrew Walker)It give me back the total for each client, not for each type
-
Re: Sum, aggr and total
Juan Patricio Iorio Sep 7, 2016 12:09 PM (in response to Juan Patricio Iorio)It doesnt work
-
Re: Sum, aggr and total
Sunny Talwar Sep 7, 2016 3:18 PM (in response to Juan Patricio Iorio)I would have assumed Andrew's expression to have worked, would you be able to provide a sample to show where it isn't working for you?
-
Re: Sum, aggr and total
Nick Hoff Sep 7, 2016 4:20 PM (in response to Juan Patricio Iorio)AGGR(Sum({$<type2 = {'1*'}>}TOTAL transactions),Type)
-
Re: Sum, aggr and total
Juan Patricio Iorio Sep 7, 2016 4:21 PM (in response to Nick Hoff)it dosnt work, i need it in every row
-
-
-
-
-
Re: Sum, aggr and total
Sunny Talwar Sep 7, 2016 4:32 PM (in response to Juan Patricio Iorio)-
example (1).qvw 150.8 K
-
Re: Sum, aggr and total
Juan Patricio Iorio Sep 8, 2016 12:19 PM (in response to Sunny Talwar )Great!
Thank you very much!
-