Question
3
Replies
72
Views
Blue Cross and Blue Shield of Minnesota
Posted: 1 year ago
Last activity: 1 year ago
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
Posted: 1 year ago
Posted: 1 year ago
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.
Posted: 1 year ago
Please ignore. It's my code that is doing this.
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