Newbie - BAQ If Statement

Yahoo Archive
1
I have this fixed.

I think that I don't understand the refresh situation completely.

After exiting from the BAQ, I was able to execute it sucessfully the
second time.

--- In vantage@yahoogroups.com, "lapulsifer" <sharon.pulsifer@...>
wrote:
>
> We run Vantage 4.03.403b in a SQL Server Environment.
>
> I'm trying to enter a Calculated field on a BAQ that will work the
same
> as an Excel If statement. I don't know progress code at all, but
have
> found a little information on this group.
>
> When I test my calculated field, I get a syntax error. Can anyone
see
> a problem with this CALC Field setup?
>
> Field Name: QuotSearch
>
> Expression: (if ( QuoteHed.ParentQuoteNum > 0 ) then (
> QuoteHed.ParentQuoteNum ) else (QuoteHed.QuoteNum) )
>
> Format: >>>>>>>>9
>
> Data Type: Integer
>
2
We run Vantage 4.03.403b in a SQL Server Environment.

I'm trying to enter a Calculated field on a BAQ that will work the same
as an Excel If statement. I don't know progress code at all, but have
found a little information on this group.

When I test my calculated field, I get a syntax error. Can anyone see
a problem with this CALC Field setup?

Field Name: QuotSearch

Expression: (if ( QuoteHed.ParentQuoteNum > 0 ) then (
QuoteHed.ParentQuoteNum ) else (QuoteHed.QuoteNum) )

Format: >>>>>>>>9

Data Type: Integer
3
I ran you If in 8.0 and it ran fine for me.

Scott

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
lapulsifer
Sent: Monday, October 29, 2007 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Newbie - BAQ If Statement

We run Vantage 4.03.403b in a SQL Server Environment.

I'm trying to enter a Calculated field on a BAQ that will work the same
as an Excel If statement. I don't know progress code at all, but have
found a little information on this group.

When I test my calculated field, I get a syntax error. Can anyone see
a problem with this CALC Field setup?

Field Name: QuotSearch

Expression: (if ( QuoteHed.ParentQuoteNum > 0 ) then (
QuoteHed.ParentQuoteNum ) else (QuoteHed.QuoteNum) )

Format: >>>>>>>>9

Data Type: Integer



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
4
Thanks for trying. I had a typo in my original message. We run
Vantage 8.03.403b, not 4.03.403b.

I'll keep playing around with it.

--- In vantage@yahoogroups.com, "Scott Litzau" <scott.litzau@...>
wrote:
>
> I ran you If in 8.0 and it ran fine for me.
>
> Scott
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> lapulsifer
> Sent: Monday, October 29, 2007 10:43 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Newbie - BAQ If Statement
>
> We run Vantage 4.03.403b in a SQL Server Environment.
>
> I'm trying to enter a Calculated field on a BAQ that will work the
same
> as an Excel If statement. I don't know progress code at all, but
have
> found a little information on this group.
>
> When I test my calculated field, I get a syntax error. Can anyone
see
> a problem with this CALC Field setup?
>
> Field Name: QuotSearch
>
> Expression: (if ( QuoteHed.ParentQuoteNum > 0 ) then (
> QuoteHed.ParentQuoteNum ) else (QuoteHed.QuoteNum) )
>
> Format: >>>>>>>>9
>
> Data Type: Integer
>
>
>
> 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
>