| Author |
Message |
jbalbo
Senior Member
Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
|
   Topic: adding a total but only for group value
Posted: 28 Jan 2013 at 11:59am |
|
fairly sure I'll explain this wrong....
I have data I have grouped by date and a flag(a 0 or 1)
on the group footer (gf4) I display the flag and the effdate this way for the most recent date I get the flag value , then in GF3 I have the service date since the service date can share multiple effdate I only want to add the values together on gf4 then surpress gf3 if >0
example
joe jones
detail effdate(s) 12/31/10 -flag 1
"" 1/1/11 0
gf4 - effdate 1/1/11 - flag 0
detail effdate(s) 1/31/11 -flag 1
"" 2/1/11 0
gf4 2/1/11 - 0
gf3 -service date 2/1/11 (although the sum of flag is 2 ) I want to call it 0 since the last value(most recent) on both gf3 are 0 if one of the most recent was 1 then want to call it 1 on gf3
Thanks
Joe
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jan 2013 at 4:19am |
Joe,
can you explain basically what you are trying to accomplish in general?
|
|
IP Logged |
|
jbalbo
Senior Member
Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
|
Posted: 29 Jan 2013 at 5:20am |
|
yes sorry....
I'll try...
detail section show"effective date" and "type" sorted by effective date
then I put the last value of type in GF4 which is payer
there can be one or many GF4 or payers but the last or most recent is in the footer.
I then want to surpress (GF3 value which is service date) if any of the GF4 are 1 or the total is > 0
detail section 1/1/11 - 0
1/2/11 - 1
GF4 1<- just a formula moving the value to it
detail section 2/1/11 - 1
2/2/11 - 0
GF4 0
GF3 Service Date (surpress if any GF4 prior have a 1)
Its the checking of GF4 to surpress GF3 Im hung up on
Hope this helps....Thanks
Edited by jbalbo - 29 Jan 2013 at 5:22am
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 29 Jan 2013 at 5:31am |
I am not sure what all your groups are.
can you show some raw data and then explain what you are trying to get to without your current set up? I suggest this as I am not seeing solution to your problem based on your current design but operhaps there is another solution in general.
What I can gather is you are trying to show or hide a services by a customer if the customer still owes on that service but it is a convoluted process to determine if it is paid or not. Something like that?
|
|
IP Logged |
|
jbalbo
Senior Member
Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
|
Posted: 29 Jan 2013 at 7:28am |
| Below is
the data so I want to display starttime (8/13/12) |
|
|
|
|
|
|
|
| if
the last value of Medi is elig type 0 and last value of MBHP is 0 |
|
|
|
|
| Same for 8/14… etc |
|
|
|
|
|
|
|
|
|
| ID |
|
STARTTIME |
Effective_As_Of_Date |
Eligibility_Type |
Med |
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/13/2012 2:00:00 PM |
1/1/2012 12:00:00 AM |
1 |
Medi |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/13/2012 2:00:00 PM |
12/16/2011 12:00:00 AM |
1 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/13/2012 2:00:00 PM |
1/8/2012 12:00:00 AM |
0 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/13/2012 2:00:00 PM |
1/11/2012 12:00:00 AM |
1 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/13/2012 2:00:00 PM |
8/9/2012 12:00:00 AM |
0 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/14/2012 1:00:00 PM |
1/1/2012 12:00:00 AM |
1 |
Medi |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/14/2012 1:00:00 PM |
12/16/2011 12:00:00 AM |
1 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/14/2012 1:00:00 PM |
1/8/2012 12:00:00 AM |
0 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/14/2012 1:00:00 PM |
1/11/2012 12:00:00 AM |
1 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/14/2012 1:00:00 PM |
8/9/2012 12:00:00 AM |
0 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/16/2012 3:00:00 PM |
1/1/2012 12:00:00 AM |
1 |
Medi |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/16/2012 3:00:00 PM |
12/16/2011 12:00:00 AM |
1 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/16/2012 3:00:00 PM |
1/8/2012 12:00:00 AM |
0 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/16/2012 3:00:00 PM |
1/11/2012 12:00:00 AM |
1 |
MBHP |
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 1,000,604 |
|
8/16/2012 3:00:00 PM |
8/9/2012 12:00:00 AM |
0 |
MBHP |
|
|
IP Logged |
|
jbalbo
Senior Member
Joined: 17 Feb 2011
Online Status: Offline
Posts: 219
|
Posted: 29 Jan 2013 at 7:29am |
|
in the case above it would be surpressed
if medi was 0 then it would be displayed
Thanks
|
|
IP Logged |
|
|
|
