CorVue Question

Try this:
Remember to change the 'Actual Margin' to the table or column name.

@(Actual Margin) <0 ?"Under":
@(Actual Margin) <19.99 ?"Risk":
@(Actual Margin) <40 ?"Zone":
@(Actual Margin) >40.01 ?"Great"

This is just real quick out of my head, you might have to "fine tune" it
a little.



This is just a example on the po table

@[PO Num] <1800 ?"Under":@[PO Num] <2000 ?"Risk": @[PO Num] <8000
?"zone":@[PO Num] >8001 ?"great"
Judd
Custom Hoists, Inc.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dave.miller2@...
Sent: Wednesday, February 22, 2006 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] CorVue Question

I'm trying to write an If-Then Equation for a new Column in one of my
queries; it has multiple if/then's. Is that possible???
It looks like this....
If Actual Margin < 0 then 'Under'
If Actual Margin <> .01-19.99 then 'Risk'
If Actual Margin <> 20-40 then 'Zone'
If Actual Margin >= 40.01 then 'Great'
Any direction would be greatly appreciated!
Thank you!
Dave Miller

[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
I�m trying to write an If-Then Equation for a new Column in one of my queries; it has multiple if/then�s. Is that possible???
It looks like this�.
If Actual Margin < 0 then �Under�
If Actual Margin <> .01-19.99 then �Risk�
If Actual Margin <> 20-40 then �Zone�
If Actual Margin >= 40.01 then �Great�
Any direction would be greatly appreciated!
Thank you!
Dave Miller

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

You can use nested ifs.

E.g.

(@[Balance],$ > 500) ? 'Plus' :(@[Balance],$ < -500) ? ('Neg') :
('Neither')


--- In vantage@yahoogroups.com, dave.miller2@... wrote:
>
> I'm trying to write an If-Then Equation for a new Column in one of
my queries; it has multiple if/then's. Is that possible???
> It looks like thisÂ….
> If Actual Margin < 0 then `Under'
> If Actual Margin <> .01-19.99 then `Risk'
> If Actual Margin <> 20-40 then `Zone'
> If Actual Margin >= 40.01 then `Great'
> Any direction would be greatly appreciated!
> Thank you!
> Dave Miller
>
> [Non-text portions of this message have been removed]
>
What is the name of your company and what type of products do you
produce? Do you know why your margins are so variable?

Cheryl Connolly
651-697-7106

UV Color, Inc.
cconnolly@...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of dave.miller2@...
Sent: Wednesday, February 22, 2006 10:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] CorVue Question

I'm trying to write an If-Then Equation for a new Column in one of my
queries; it has multiple if/then's. Is that possible???
It looks like this....
If Actual Margin < 0 then 'Under'
If Actual Margin <> .01-19.99 then 'Risk'
If Actual Margin <> 20-40 then 'Zone'
If Actual Margin >= 40.01 then 'Great'
Any direction would be greatly appreciated!
Thank you!
Dave Miller

[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