List of Microsoft Excel functions supported in Xcelsius 2008

Xcelsius uses MS Excel as a base to create Interactive Dashboards. Xcelsius does not support all the functions available in MS Excel. I have put together the list of MS Excel functions that are supported by Xcelsius 2008. This list can also be found in Xcelsius User’s Guide. Following is the List.

Download Excel File here

Related Posts:

  • donald

    And you can use the Xcelsius 2008 SDK to add to this list by writing your own custom function support

  • cristina

    Hi i was looking around of google about how to do the 3 tabs you have in this page… where can i get that code?

    • http://myxcelsius.com/ Kalyan Verma

      @ Cristina,

      It is an Interactive SWF, created using Xcelsius 2008. Do you want to know how to create it using Xcelsius? or are you looking for a wordpress plugin that can do a similar job?

      Regards,
      Kalyan Verma
      Admin

  • http://none Kate

    Hi there,

    I have a question in relation to the INDEX and SMALL formula – do you know if they support them together such as =INDEX($C$2:$C$9, SMALL($F$2:$F$9, G4),1)

    I have a list view box showing the result of this. Before I render it out I can see the result but when I export it all I get is #NUM!

    Any help much appreciated!

    Cheers
    Kate

  • Roberto

    Hi together,
    I have a problem: when I open xcelsius 2008 and clink on CONNECT for connect it with BPC 7.5, the error pop-up appear with “ActiveX component cann’t create object”, and the connection doesn’t work. Why??

    Roberto

  • http://www.arangote.com Bombet Arangote

    Hi,

    Can Xcelsius read array formula? I have a model that sumifs with multiple conditions and I use array. I am not sure if loading this into Xcelsius would affect the computation of these formula.

    Thanks.

  • http://myxcelsius.com/ Kalyan Verma

    @Bombet, Xcelsius does not support Excel Array functionality at this moment

    • Fred

      Do you know from a reliable source when it will be supported?

  • http://myxcelsius.com/ Kalyan Verma

    @Fred, no info yet on the array function. We will be one of the first to break the news once available. Stay tuned. Thanks

  • Bernd

    Hello everybody,
    yesterday I have wasted a lot of time trying to create a Xcelsius 2008 dashboard by using an excel-spreadsheet with arrays. Thanks to your website I now have learned about the problem xcelsius has with arrays. However, can you tell me, whether there exists a document/information about all the other “excel-incompatibilities” of xcelsius in addition of the list of not supported excel-functions!? Thanks in advance for your reply.

  • http://www.mygeodashboard.com James Garrity

    Per this forum( http://forums.sdn.sap.com/thread.jspa?threadID=1667292 ), and from my head-wall banging experience just now I believe DCOUNTA is NOT SUPPORTED, or not in its full capacity. My DCOUNTA works beautifully in my spreadsheet, and it is a very robust function, but when I preview my dashboard it doesn’t deliver.

    Have you run across this? If this is true, perhaps you should remove it from your list (as I and I’m sure others use it as absolute truth – a great reference).

    Cheers,

    Jim

    • http://www.mygeodashboard.com James Garrity

      SOLVED: DCOUNTA does work! NOTE: DCOUNTA does work, however, it doesn’t perform the same way that it does in Excel (which is very confusing). In my case, in excel when I left a criteria cell blank, it would basically omit that criteria. As if to say in SQL (Considering fields County, Industry and Class)

      Select * From Table Where County = Wicomico, MD AND Industry = Retail

      However, once compiled as an SWF it was as if it were saying:

      Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = “”

      So…to make it work you must use the WILDCARD Operator * in the criteria cell to indicate ALL.

      Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = *

      And it works…

      See a modified example dashboard of the difference between * and “” at: http://staff.salisbury.edu/~jrgarrity/dcounta.swf
      Download the Excel Model at: http://staff.salisbury.edu/~jrgarrity/dcounta.xls

      See more DCOUNTA functionlity at:
      http://office.microsoft.com/en-us/excel-help/dcounta-HP005209050.aspx

  • Bernd

    Hello James,
    thanks a lot for your feedback and the link. I suppose that I will have to set up my own little “database” to note all the undocumented problems unless SAP is able to provide us with such an information.
    Bernd

  • James Garrity

    Bernd,

    DCountA does work! :

    I had a similar issue with Xcelsius and DCOUNTA does work! NOTE: DCOUNTA does work, however, it doesn’t perform the same way that it does in Excel (which is very confusing). In my case, in excel when I left a criteria cell blank, it would basically omit that criteria. As if to say in SQL (Considering fields County, Industry and Class)

    Select * From Table Where County = Wicomico, MD AND Industry = Retail

    However, once compiled as an SWF it was as if it were saying:

    Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = “”

    So…to make it work you must use the WILDCARD Operator * in the criteria cell to indicate ALL.

    Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = *

    And it works…

    See a modified example dashboard of the difference between * and “” at: http://staff.salisbury.edu/~jrgarrity/dcounta.swf
    Download the Excel Model at: http://staff.salisbury.edu/~jrgarrity/dcounta.xls

    See more DCOUNTA functionlity at:
    http://office.microsoft.com/en-us/excel-help/dcounta-HP005209050.aspx

  • Saad

    INDIRECT() does not work :(

  • Fara

    Hi, ROUND() is not working in my dashboard xcelsius 2008. is three any other w/around ..

  • Saad

    Round works for me.

  • Dumb_Xcelsius

    ROW and COLUMN are shown as supported functions in the Xcelsius Help document!! But in reality it does not support it!! Using Vlookup drastically slows down the report!!!! DUMB TOOL!!