Inputsum

[dickelsa]

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

[dickelsa]

Update:

I found out that somehow, my field is not turned into an inputfield.

Can someone please help me?

Best regards,

Dick