Question
Blue Cross and Blue Shield of Minnesota
US
Last activity: 17 Feb 2021 10:20 EST
group by in report def
I have a grid with number of columns displaying claims in rows:Claim Number | Pharmacy Name | Net Paid Amnt
Claim123 abc 2.25
Claim123 abc -2.25
Claim123 abc 2.25
Claim234 bcd 1.25
Requirement: I want to display...
Claim Number | Pharmacy Name | Net Paid Amnt
Claim123 abc 2.25
Claim234 bcd 1.25
...rolled up Net Paid Amt.
Accepted Solution
Pegasystems Inc.
IN
Hi Srikanth,
In report definition for any integer or currency field, you can follow the below approach:
I have created to work objects (net_amt=2.25,-2.25) whose sum will be 0.
In the report definition select Sum in the summarize field(Sum option will be present for integer or currency field but not for text field) :
NOTE: the Sort order should be set properly (in your case it should be 1 for claim no).
Hi Srikanth,
In report definition for any integer or currency field, you can follow the below approach:
I have created to work objects (net_amt=2.25,-2.25) whose sum will be 0.
In the report definition select Sum in the summarize field(Sum option will be present for integer or currency field but not for text field) :
NOTE: the Sort order should be set properly (in your case it should be 1 for claim no).
Regards,
Vikash
Blue Cross and Blue Shield of Minnesota
US
Thanks for reply Vikash.
I have 2.06, 2.06, -2.06. When I tried Sum, the report returns 4.12 and -2.06.
I can see it worked for you but not sure why it's not working for me. My netpaidamount is integer type. No custom code.