Register

How to get a Formula to output a text.

neg177
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
Amaya
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

ChrisHeathcote
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 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA