Skip to Content
0
Former Member
Feb 28, 2009 at 05:29 PM

Xcelsius Not ignoring blank rows at the end

20 Views

Hello,

I'm having a problem on Xcelsius so I figured I would throw it up here and see if anyone could help. The things that gets me is that it's functing correctly in design mode, but doesn't seem to work in preview or export mode.

I am running Xcelsius Version 5.1.2.0 Build Number 12,1,2,439

So I have a formula written into Excel (See image below)

https://sapmats-us.sap-ag.de/download/download.cgi?id=F74NGC1MRFIP3U0FFL4P3AZ5QUWDGFN011KK27XCUX5W6YL7NV&contype=image/pjpeg&password=https://sapmats-us.sap-ag.de/download/download.cgi?id=F74NGC1MRFIP3U0FFL4P3AZ5QUWDGFN011KK27XCUX5W6YL7NV&contype=image/pjpeg&password=">https://sapmats-us.sap-ag.de/download/download.cgi?id=F74NGC1MRFIP3U0FFL4P3AZ5QUWDGFN011KK27XCUX5W6YL7NV&contype=image/pjpeg&password=>

As you can see this formula is set up to return blank values if data does not exist. without going into the specifics of the dashboard, you can see that it's working correctly in Excel.

Below is a screenshot of Xcelsius in Design mode, once again function correctly, and I have the box to Ignore Blank Values at the end checked.

https://sapmats-us.sap-ag.de/download/download.cgi?id=TOVLBOLX838TGLB4FWDYVXVMYNAGGWUCUYNZB1USSUHRV3AKUP&contype=image/pjpeg&password=https://sapmats-us.sap-ag.de/download/download.cgi?id=TOVLBOLX838TGLB4FWDYVXVMYNAGGWUCUYNZB1USSUHRV3AKUP&contype=image/pjpeg&password=">https://sapmats-us.sap-ag.de/download/download.cgi?id=TOVLBOLX838TGLB4FWDYVXVMYNAGGWUCUYNZB1USSUHRV3AKUP&contype=image/pjpeg&password=>

When I enter preview mode (or try to export to Word, PDF, Powerpoint or SWF, see below).

[url]https://sapmats-us.sap-ag.de/download/download.cgi?id=O8OIVJYWV9KKORALXSX9QPWH11OQS1I77K0R5Y0QKCLU7H1EOT&contype=image/pjpeg&password=[/url]

I don't understand why it would be doing this, can anyone provide some assitance?

Thanks,

Domenic

(BTW, I'm an internal SAP Employee)

Edited by: Domenic Colasante on Feb 28, 2009 6:29 PM