Skip to Content
Feb 20, 2014 at 12:28 AM

Excel is adding blanks to a string in runtime


Hi everyone,

I'm using SAP Dashboards and I'm having this currently wierd behaviour.

What I have to do is to create a list of closed months (eg: today is February 19th, so last closed month is January). Of course this logic is implemented in excel, and will automatically refresh when real month changes (next time, in March).

The thing is, in designer mode, I see the list correctly, but when I run the dashboard, it's adding me a blank just before month string begins:

Designer (Excel):

For reference, row of "Actual date" is no. 2.

Runtime (swf):

(months are in Spanish)

This is not a visualization effect, because I tested different months with Length() and actually there is a +1 difference between runtime and designer.

Because it's never wierd enough, January seems immune to this bug (no matter what year).

Let me share the Excel formula (cells references are from screen 1): =TEXT(MONTH($I$2;-G3);"mmmm")&" "&RIGHT(H3;4)

I tried using different formulas to accomplish this, but the issue persists.

Any suggestions?

Thanks in advance,



excel.png (4.4 kB)
combo.png (9.2 kB)