cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Var_Main Variable

HercRentals
Explorer
0 Likes
268

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

MichaelGrackin
Contributor

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.

HercRentals
Explorer
0 Likes

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