1 Reply Latest reply: Feb 21, 2018 2:27 AM by dick elsman RSS

    Inputsum

    dick elsman

      Hi all,

       

      I have a problem with the inputsum() aggregation.

      i cannot use it somehow.

      this is the script:

       

      INPUTFIELD FactTable.test;

       

      FactTable:

      LOAD Date,

           [Acc code],

           Value as test

      FROM

      [DC.xlsx]

      (ooxml, embedded labels, table is Blad1);

       

      Descr:

      LOAD [Acc code],

           Descr

      FROM

      [DC.xlsx]

      (ooxml, embedded labels, table is Blad2);

       

      Calendar:

      Load Date,

      Year(Date)&'-'&Month(Date) as YM

      RESIDENT FactTable;

       

      when i change INPUTFIELD to just "test", it says it creates duplicate keys so it doesnt work.

      Can anyone help me?

      dashboard with source is attached.

       

      Best regards,

       

      Dick