Skip to Content
0
Former Member
Apr 29, 2014 at 02:48 PM

Add a buffer space between two parts of formula

759 Views


I have a formula that combines a date command (field) and some text at the end. It's repeated for each row of a cross-tab, so they are stacked vertically. I need to add a buffer of blank space in between the date command and the text at then end, so that each row looks the same no matter how long the month text is in my date field.

Formula:

ToText({Command.MyDate}, "MMMM yy") & " " & " MyText "

For example, when the date is April 2014 it would look like:

"April 2014 My Text" But if the date is September 2014 it looks like:

"September 2014 My Text"

I would like for the MyText's to line up. As you can see in my formula I thought entering a set amount of blank spaces would somehow add this buffer, but it didn't and I understand why.

I should probably explain why I'm even doing this. I have a cross tab in a report and I need a label to repeat for each row in addition to the Row Name. The number of rows is always changing, so I can't use static text boxes. The best way I found was to add the additional labels to the Row Name using a formula.

Any advice is appreciated!