Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in my table there are documents with different doctypes. In my diagram i want to show only the the documents in wich the documenttype is a certain one. i don`t know if i should use a dynamic dimension or a formula!? i tried to type this in my formula but it doesn`t work...
=SUM({1<VerkaufsdokumentKopf.Dokumenttyp={'2'}>} VerkaufsdokumentKopf.Grundlage)
VerkaufsdokumentKopf.Dokumenttyp is a small int field what is wrong in my expression? or what is a solution for my problem?
It works fine on my side. Take a look at attachment.
I've never heard about such notation, but try this:
=SUM({1<Dokumenttyp={"2"}>} Grundlage)
thx for your replys... no i found out that my problem is a different one my concatenate doesn`t work right. i have 2 tables one with fields x y z and the other with u and v now i load them in this way
newtable:
load x as a, y as b, z as c from table1;
concatenate
load u as a ,v as lol from table2;
my problem s that in newtable there are only the values ou of table1 the values of table2 are missing
It works fine on my side. Take a look at attachment.
i had qualified the fields...=) i know i`m a idiot
Nobody is protected from this. And it happens with the best of us