Question
3
Replies
77
Views
Blue Cross and Blue Shield of Minnesota
Posted: October 26, 2019
Last activity: October 28, 2019
Closed
Solved
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.
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