Need text with in a formula 1

[brecat77]

i am trying to make a formula to display correctly. What i need is this

{@Budget4}#{@Budget1} which should display the data

example 043#0017. I am having trouble getting the # in between in the formula. I do not want to do a text field that has the "formula # formula". I need a separate formula that contain the other 2 with a # in between them.

 

[IanWaterman]

Just place these formula in a text box and type the # between them.

Ian

 

[brecat77]

i have this already, the problem i have is that i need a formula that would contain the textbox that you are suggesting....for example

Formula: {@Budget4}#{@Budget1}. I do not want to have to use a Text box to complete this task. i need to use a formula field that will contain the formula, the text, and then another formula.

 

[IanWaterman]

Try

@Combined
{@Budget4}&"#"&{@Budget1}

Ian