Dennis,
I'm not sure I totally understand what you are doing ...
If I'm reading your message correctly --- Try ---
* Setup a calculated field "new-var = IIF(variable = ?,0,variable) " -- in
other words if "variable" is unknown force it to zero else leave the value
as is.
Then add a filter to your report to say that if new-var = 0 skip the record.
Am I any where close ?
By the way this also works when you are trying to do math on fields that may
be unkown.
Todd Anderson
J. Rubin & Co.
-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: Wednesday, September 13, 2000 8:04 AM
To: vantage@egroups.com
Subject: [Vantage] unknown factor
<http://www.egroups.com/> eGroups My
<http://www.egroups.com/mygroups> Groups | vantage Main
<http://www.egroups.com/group/vantage> Page
If anyone can help with this I would greatly appreciate it. I have a report
builder report made in progress that sorts and totals labor entries by
departments. For each operation, there may or may not be up to 5 variances
recorded, The trouble I have is with the unkown factor "?" when there
aren't any variances recorded against an enty, the report still leaves 5
blank lines under each entry, I can fix this by manually hitting delete when
setting unkown factor for each variance field, and this works as long as i'm
in report builder, but report builder does not save this change when I exit.
I can't put this out on the menu tree structure for general access like
this.
Thanks
Dennis L Houghton
[Non-text portions of this message have been removed]
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
I'm not sure I totally understand what you are doing ...
If I'm reading your message correctly --- Try ---
* Setup a calculated field "new-var = IIF(variable = ?,0,variable) " -- in
other words if "variable" is unknown force it to zero else leave the value
as is.
Then add a filter to your report to say that if new-var = 0 skip the record.
Am I any where close ?
By the way this also works when you are trying to do math on fields that may
be unkown.
Todd Anderson
J. Rubin & Co.
-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: Wednesday, September 13, 2000 8:04 AM
To: vantage@egroups.com
Subject: [Vantage] unknown factor
<http://www.egroups.com/> eGroups My
<http://www.egroups.com/mygroups> Groups | vantage Main
<http://www.egroups.com/group/vantage> Page
If anyone can help with this I would greatly appreciate it. I have a report
builder report made in progress that sorts and totals labor entries by
departments. For each operation, there may or may not be up to 5 variances
recorded, The trouble I have is with the unkown factor "?" when there
aren't any variances recorded against an enty, the report still leaves 5
blank lines under each entry, I can fix this by manually hitting delete when
setting unkown factor for each variance field, and this works as long as i'm
in report builder, but report builder does not save this change when I exit.
I can't put this out on the menu tree structure for general access like
this.
Thanks
Dennis L Houghton
[Non-text portions of this message have been removed]
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)