Inputsum

dickelsa — Wed, 21 Feb 2018 07:03:08 GMT

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

Re: Inputsum

dickelsa — Wed, 21 Feb 2018 07:27:37 GMT

Update:

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

Can someone please help me?

Best regards,

Dick