Resetting a value

Yahoo Archive
1
YAHOO!!!

It worked. I've been racking my brain for days on this.
THANKS!!!

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 29, 2004 5:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Resetting a value


OperValueX = IIF(MaxOpCount <= X,
IIF(OpCount = X,OperDesc,' ')
, ' ')
in all cases above X=the number of the oper position being dealt with 1,2,3 etc.....
so ther ewould be a calculated field for OperValue1 OperValue2 and so forth
If the maximum number of opers for the group is for instance 4 then the calculation for OperValue5 would fail the first test and fill the value with ' ' (blank). The ' ' on the false value in the "inner" test really does not matter since they will get filled in as they are encountered.

I'm still not sure though if the pre-pass aggregate that determines MacOpCount can be done since the OperCOunt itself would be an aggregate or running total. But maybe it would work. RB will tell you in no uncertain terms if not.

-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, September 29, 2004 3:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Resetting a value


What do you mean by placing a test outside a test?

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 29, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Resetting a value


I think I would approach it using a pre-pass aggregate for Maximum on the oper count in the group (resetting at each group) and then in the assignment calculation for the values place a test outside the test now being used to see if the value being loaded is greater than the max op count for the gorup. If greater then load with zero, blank or ? (unknown) otherwise load a value as now. Only hitch might be convoluted rules in RB for when you can use a pre-pass aggregate value. It might complain that it is an illegal use.
-Todd C.


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, September 29, 2004 8:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Resetting a value


I have a calculated value that gets recalculated for each group if a certain condition is met. The problem I'm having is that when that condition is not met, the value of that variable is the same from the last group. How can I reset all variable before each group so that I won't see a calculation from the last group?

Example,
In the first group, Op 1 is SAW, Op 2 it DRILL and Op 3 is TURN. Then in the next group, there is only Op 1 and Op 2. But since Op 3 has been assigned in the previous group, it shows up in the next group.

Any ideas how to avoid this?

Thanks,
Jasper




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
< http://us.ard.yahoo.com/SIG=129fhk6qj/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1096552152/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
< http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=605391509>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service < http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129rm758a/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1096576505/A=2319498/R=0/SIG=11thfntfp/*http://www.netflix.com/Default?mqso=60185352&partid=5285298> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2319498/rand=449559615>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
I have a calculated value that gets recalculated for each group if a certain condition is met. The problem I'm having is that when that condition is not met, the value of that variable is the same from the last group. How can I reset all variable before each group so that I won't see a calculation from the last group?

Example,
In the first group, Op 1 is SAW, Op 2 it DRILL and Op 3 is TURN. Then in the next group, there is only Op 1 and Op 2. But since Op 3 has been assigned in the previous group, it shows up in the next group.

Any ideas how to avoid this?

Thanks,
Jasper




[Non-text portions of this message have been removed]
3
I think I would approach it using a pre-pass aggregate for Maximum on the oper count in the group (resetting at each group) and then in the assignment calculation for the values place a test outside the test now being used to see if the value being loaded is greater than the max op count for the gorup. If greater then load with zero, blank or ? (unknown) otherwise load a value as now. Only hitch might be convoluted rules in RB for when you can use a pre-pass aggregate value. It might complain that it is an illegal use.
-Todd C.


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, September 29, 2004 8:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Resetting a value


I have a calculated value that gets recalculated for each group if a certain condition is met. The problem I'm having is that when that condition is not met, the value of that variable is the same from the last group. How can I reset all variable before each group so that I won't see a calculation from the last group?

Example,
In the first group, Op 1 is SAW, Op 2 it DRILL and Op 3 is TURN. Then in the next group, there is only Op 1 and Op 2. But since Op 3 has been assigned in the previous group, it shows up in the next group.

Any ideas how to avoid this?

Thanks,
Jasper




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129fhk6qj/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1096552152/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=605391509>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
What do you mean by placing a test outside a test?

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 29, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Resetting a value


I think I would approach it using a pre-pass aggregate for Maximum on the oper count in the group (resetting at each group) and then in the assignment calculation for the values place a test outside the test now being used to see if the value being loaded is greater than the max op count for the gorup. If greater then load with zero, blank or ? (unknown) otherwise load a value as now. Only hitch might be convoluted rules in RB for when you can use a pre-pass aggregate value. It might complain that it is an illegal use.
-Todd C.


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, September 29, 2004 8:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Resetting a value


I have a calculated value that gets recalculated for each group if a certain condition is met. The problem I'm having is that when that condition is not met, the value of that variable is the same from the last group. How can I reset all variable before each group so that I won't see a calculation from the last group?

Example,
In the first group, Op 1 is SAW, Op 2 it DRILL and Op 3 is TURN. Then in the next group, there is only Op 1 and Op 2. But since Op 3 has been assigned in the previous group, it shows up in the next group.

Any ideas how to avoid this?

Thanks,
Jasper




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129fhk6qj/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1096552152/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=605391509>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
5
OperValueX = IIF(MaxOpCount <= X,
IIF(OpCount = X,OperDesc,' ')
, ' ')
in all cases above X=the number of the oper position being dealt with 1,2,3 etc.....
so ther ewould be a calculated field for OperValue1 OperValue2 and so forth
If the maximum number of opers for the group is for instance 4 then the calculation for OperValue5 would fail the first test and fill the value with ' ' (blank). The ' ' on the false value in the "inner" test really does not matter since they will get filled in as they are encountered.

I'm still not sure though if the pre-pass aggregate that determines MacOpCount can be done since the OperCOunt itself would be an aggregate or running total. But maybe it would work. RB will tell you in no uncertain terms if not.

-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, September 29, 2004 3:35 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Resetting a value


What do you mean by placing a test outside a test?

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, September 29, 2004 10:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Resetting a value


I think I would approach it using a pre-pass aggregate for Maximum on the oper count in the group (resetting at each group) and then in the assignment calculation for the values place a test outside the test now being used to see if the value being loaded is greater than the max op count for the gorup. If greater then load with zero, blank or ? (unknown) otherwise load a value as now. Only hitch might be convoluted rules in RB for when you can use a pre-pass aggregate value. It might complain that it is an illegal use.
-Todd C.


-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Wednesday, September 29, 2004 8:49 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Resetting a value


I have a calculated value that gets recalculated for each group if a certain condition is met. The problem I'm having is that when that condition is not met, the value of that variable is the same from the last group. How can I reset all variable before each group so that I won't see a calculation from the last group?

Example,
In the first group, Op 1 is SAW, Op 2 it DRILL and Op 3 is TURN. Then in the next group, there is only Op 1 and Op 2. But since Op 3 has been assigned in the previous group, it shows up in the next group.

Any ideas how to avoid this?

Thanks,
Jasper




[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
< http://us.ard.yahoo.com/SIG=129fhk6qj/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1096552152/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
< http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=605391509>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service < http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links







Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129rm758a/M=298184.5285298.6392945.3001176/D=groups/S=1705007183:HM/EXP=1096576505/A=2319498/R=0/SIG=11thfntfp/*http://www.netflix.com/Default?mqso=60185352&partid=5285298> click here
<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=:HM/A=2319498/rand=449559615>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]