8 Replies Latest reply: Jan 20, 2012 10:20 AM by vinsse2001 RSS

    error message when creating expression on crosstable

      Hello,

       

      I have the following error message when I add an expression in my graph : "You have attempted to apply a numerical expression, which is not uniquely defined for the specified variable. In order to use this variable in expressions relying on number of occurrences, please read it a second time under a new name from its primary table."

      error.jpg

      This is what I wish to make:

      - Import a crossed table (cf example below, and associated script)

      - To create a line chart (sum on all the projects), with in dimension the date

       

      After import data, I create a new chart, select 'line chart', the dimension 'date' and the expression Sum(myData). The error appears if I choose 'Sum' and ' myData ' in the drop-down lists, but there is no error if I write directly the expression. However, it does not generate the expected graph.

       

      What is the good approach ?

      Thank you in advance !

       

      Vincent

      ---------------------------------------------------------------------------------------------------------------------------------

       

      Here are the test data :

       

      project01/01/201202/01/201203/01/201204/01/201205/01/201206/01/201207/01/201208/01/201209/01/201210/01/201211/01/201212/01/201213/01/2012
      p11000000000000
      p20000006000000
      p30000005000000
      p40000000100000
      p50000010010400
      p60011000000000
      p70000010010300
      p80000000000000
      p900001000003200
      p100010055010009
      p11000650000000880
      p120000000005000
      p130660000000000
      p140000000000000
      p150000000000000

       

      Here is the script generated for the import of the Excel file :

       

      CrossTable(date, myData)

      LOAD project,

           40909,

           40910,

           40911,

           40912,

           40913,

           40914,

           40915,

           40916,

           40917,

           40918,

           40919,

           40920,

           40921

      FROM

      D:\Temp\Classeur2.xlsx

      (ooxml, embedded labels, table is Feuil1);

       

      PS: I saw that the discussion n°146856 treated with the same subject, but finally has no answer...

      PPS : For french search in this forum :), the error message is "Vous avez tenté d'appliquer une expression numérique qui n'est pas définie de façon unique pour la variable concernée. Afin d'utiliser cette variable dans des expressions basées sur le nombre d'occurences, rechargez-la sous un nouveau nom à partir de sa table principale."