Error Message With BAQ

Thank you, it was the quotes on the 0. Much appreciated

--- In vantage@yahoogroups.com, Joe Englert <englertj@...> wrote:
>
> What if you remove the quotes around the "0" of your else. It might be confused about how to return a string or a number.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
> Sent: Tuesday, January 07, 2014 10:56 AM
> To: Vantage
> Subject: Re: [Vantage] Re: Error Message With BAQ
>
>
> Change the double quotes to single quotes and see if it helps.
>
>
> Jose C Gomez
> Software Engineer
>
>
> T: 904.469.1524 mobile
> E: jose@...<mailto:jose@...>
> http://www.josecgomez.com
> [http://www.josecgomez.com/images/linkedin.png%5d<http://www.linkedin.com/in/josecgomez> [http://www.josecgomez.com/images/facebook.png%5d <http://www.facebook.com/josegomez> [http://www.josecgomez.com/images/google.png%5d <http://www.google.com/profiles/jose.gomez> [http://www.josecgomez.com/images/twitter.png%5d <http://www.twitter.com/joc85> [http://www.josecgomez.com/images/wp.png%5d <http://www.josecgomez.com/professional-resume/> [http://www.josecgomez.com/images/rss.png%5d <http://www.josecgomez.com/feed/>
>
> Quis custodiet ipsos custodes?
>
> On Tue, Jan 7, 2014 at 10:52 AM, clederer@...<mailto:clederer@...> <clederer@...<mailto:clederer@...>> wrote:
>
>
> if UD01.Key4 = "Temp" then (UD01.Number01 + UD01.Number04 + UD01.Number07) else "0"
>
> I had it working and then lost the query in a database overwrite so I'm trying to remember what the query was before.
>
>
> --- In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, Jose Gomez <jose@<mailto:jose@>> wrote:
> >
> > What does your calculated field look like?
> >
> >
> > *Jose C Gomez*
> > *Software Engineer*
> >
> >
> > T: 904.469.1524<tel:904.469.1524> mobile
> > E: jose@
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> >
> >
> > *Quis custodiet ipsos custodes?*
>
> >
> >
> > On Tue, Jan 7, 2014 at 10:39 AM, clederer@ <
> > clederer@> wrote:
> >
> > >
> > >
> > > "Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> > > Please contact your System Administrator."
> > >
> > > Receiving this error after I add a calculated field into a query. The
> > > query runs before I add the calculated field. After I add the calculated
> > > field I check the syntax and it says, "Syntax is OK" The format of the
> > > calculated field and the fields it is calculating are both 'decimals.' Not
> > > sure where there is a miscommunication.
> > >
> > >
> > >
> >
>
"Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator."

Receiving this error after I add a calculated field into a query. The query runs before I add the calculated field. After I add the calculated field I check the syntax and it says, "Syntax is OK" The format of the calculated field and the fields it is calculating are both 'decimals.' Not sure where there is a miscommunication.
What does your calculated field look like?


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile
E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Tue, Jan 7, 2014 at 10:39 AM, clederer@... <clederer@...> wrote:

Â
<div>
  
  
  <p>&quot;Table: , Level:, Type: , RowID: , Text: Business Query Execution error. Please contact your System Administrator.&quot;<br>

Receiving this error after I add a calculated field into a query. The query runs before I add the calculated field. After I add the calculated field I check the syntax and it says, "Syntax is OK" The format of the calculated field and the fields it is calculating are both 'decimals.' Not sure where there is a miscommunication.

</div>
 


<div style="color:#fff;min-height:0;"></div>

if UD01.Key4 = "Temp" then (UD01.Number01 + UD01.Number04 + UD01.Number07) else "0"

I had it working and then lost the query in a database overwrite so I'm trying to remember what the query was before.

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> What does your calculated field look like?
>
>
> *Jose C Gomez*
> *Software Engineer*
>
>
> T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
>
> *Quis custodiet ipsos custodes?*
>
>
> On Tue, Jan 7, 2014 at 10:39 AM, clederer@... <
> clederer@...> wrote:
>
> >
> >
> > "Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> > Please contact your System Administrator."
> >
> > Receiving this error after I add a calculated field into a query. The
> > query runs before I add the calculated field. After I add the calculated
> > field I check the syntax and it says, "Syntax is OK" The format of the
> > calculated field and the fields it is calculating are both 'decimals.' Not
> > sure where there is a miscommunication.
> >
> >
> >
>
Change the double quotes to single quotes and see if it helps.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Tue, Jan 7, 2014 at 10:52 AM, clederer@... <clederer@...> wrote:

Â
<div>
  
  
  <p>if UD01.Key4 = &quot;Temp&quot; then (UD01.Number01 + UD01.Number04 + UD01.Number07) else &quot;0&quot;<br>

I had it working and then lost the query in a database overwrite so I'm trying to remember what the query was before.



--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> What does your calculated field look like?
>
>
> *Jose C Gomez*
> *Software Engineer*
>
>
> T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>

> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>

> <http://www.josecgomez.com/professional-resume/>

> <http://www.josecgomez.com/feed/>

>

>

> Quis custodiet ipsos custodes?



>

>

> On Tue, Jan 7, 2014 at 10:39 AM, clederer@… <

> clederer@…> wrote:

>

> >

> >

> > "Table: , Level:, Type: , RowID: , Text: Business Query Execution error.

> > Please contact your System Administrator."

> >

> > Receiving this error after I add a calculated field into a query. The

> > query runs before I add the calculated field. After I add the calculated

> > field I check the syntax and it says, "Syntax is OK" The format of the

> > calculated field and the fields it is calculating are both 'decimals.' Not

> > sure where there is a miscommunication.

> >

> >

> >

>


</div>
 


<div style="color:#fff;min-height:0;"></div>

What if you remove the quotes around the “0” of your else.  It might be confused about how to return a string or a number.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Tuesday, January 07, 2014 10:56 AM
To: Vantage
Subject: Re: [Vantage] Re: Error Message With BAQ

 

 

Change the double quotes to single quotes and see if it helps.



Jose C Gomez

Software Engineer

 


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Jan 7, 2014 at 10:52 AM, clederer@... <clederer@...> wrote:

 

if UD01.Key4 = "Temp" then (UD01.Number01 + UD01.Number04 + UD01.Number07) else "0"

I had it working and then lost the query in a database overwrite so I'm trying to remember what the query was before.



--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> What does your calculated field look like?
>
>

> *Jose C Gomez*
> *Software Engineer*
>
>
> T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
>
>
> *Quis custodiet ipsos custodes?*


>
>
> On Tue, Jan 7, 2014 at 10:39 AM, clederer@... <
> clederer@...> wrote:
>
> >
> >
> > "Table: , Level:, Type: , RowID: , Text: Business Query Execution error.
> > Please contact your System Administrator."
> >
> > Receiving this error after I add a calculated field into a query. The
> > query runs before I add the calculated field. After I add the calculated
> > field I check the syntax and it says, "Syntax is OK" The format of the
> > calculated field and the fields it is calculating are both 'decimals.' Not
> > sure where there is a miscommunication.
> >
> >
> >
>