How to get a Formula to output a text.

Regular Contributor

How to get a Formula to output a text.

Hi,

 

Not sure what the Synthax is for a Formula to return a text is. I have my Line Item formatted as Text, but want to know if I'm on the right track with the formula. 

 

IF 'Y01 Collection_Funding'.Front Book=1 THEN &"WITH PH"& ELSE &"WITHOUT PH"

 

 

Thank you 

2 REPLIES 2
Certified Master Anaplanner

Re: How to get a Formula to output a text.

Hi!

 

It is simple. Write just "text". And it works this way.

 

>

IF Flag? THEN "text1" ELSE "text2"

>

 

When you combine some text and variables or text and another text, you should use "&".

 

IF Flag? THEN "text1" & valiable1 ELSE "text2" & valiable2

 

text&valiable.png

 

Taichi

Community Boss

Re: How to get a Formula to output a text.

Break the formula out and use text formatte line items to feed in the statements. 

Also, use a boolean to inform the IF statement contained in a seperate line item. 

When you find issues arising from tricky formulas always break them out into its constituent parts.

Good luck,

Chris