Question Re: Var_Main Variable in Technology Q&A

Var_Main Variable

HercRentals — Thu, 17 Jun 2021 20:09:52 GMT

Over the past few months when I validate a var_main, it tells me the formula is defined correctly but then it inserts "\" in my formula and it won't save. Usually I can remove the "\" but this example below is quite large and I haven't been able to fix it.

Sample of what it is doing:

Char(34)+[Employee Id]+Char(34)+\",\"+Char(34)+[Employee First Name]+Char(34)+\",\"+Char(34)+[Employee Last Name]+Char(34)+\",\"+Char(34)+[Employee Work Email]+Char(34)+\",\"+Char(34)+[Job Description]+Char(34)+\",\"+Char(34)+[HireDate]+Char(34)+\",\"+Char(34)+\",\"+\",\"+Char(34)+[Home Address Line 1]+Char(34)+\",\"+Char(34)+[Home Address Line 2]+Char(34)+\",\"+Char(34)+[Home City]+Char(34)+\",\"+Char(34

Has anyone experienced this?

Re: Var_Main Variable

MichaelGrackin — Thu, 17 Jun 2021 20:39:22 GMT

Make sure your equation starts with an equal sign '='. I do not see the equal sign in your code and I have seen BusinessObjects add double quotes and other stuff to my equation if i forget to start with the equal sign.

Re: Var_Main Variable

HercRentals — Thu, 17 Jun 2021 21:31:03 GMT

Thank you Michael--I had the '=' however it wanted 2 extra '))' at the end of my equation.