internal error set analysis on dynamic pivot table

[#1]

hi

I am trying to create a dynamic chart. I know how this works and I have done it before. But now I have the problem that I have set anlysis in my Expressions and it always says internal error.

for example:

expression: sum(#Menge) - sum({$<LfdNr = {$(=min(LfdNr))}>}#Menge)

msg from macro: sum(#Menge) - sum({$<LfdNr = {(internal error)}>}#Menge)

can someone please help me.

regards,

MT

[Sokkorn]

Hi MT,

Let try this =sum(#Menge) - sum({$<LfdNr = {"=$(=min(LfdNr))"}>} [#Menge])

Do let me know.

Regards,

Sokkorn

[#3]

try with ""

sum(#Menge) - sum({$<LfdNr = {"$(=min(LfdNr))"}>}#Menge)

[#4]

I have already tried it.

now it looks like this:

msg from macro: sum(#Menge) - sum({$<LfdNr = {''}>}#Menge)

[Sokkorn]

Hi MT,

Can you share your app? It can be easy to find the root cause.

Regards,

Sokkorn

[#6]

this is my table FormelName is shown in a listbox where you can choose what expression will be shown in the pivot table.

Formeln:

LOAD * Inline [

    FormelName, Formel

    Umsatz Stk, sum(#Menge) - sum({$<LfdNr = {$(=min(LfdNr))}>}#Menge)

    1. Bestand, sum({$<#Date = {'$(=min(#Date))'}>}#Bestand)

    Endbestand, sum({$<#Date = {'$(=max(#Date))'}>}#Bestand)

    LUG,  ((sum(#Menge) - sum({$<LfdNr = {$(=min(LfdNr))}>}#Menge))/((sum({$<#Date = {'$(=min(#Date))'}>}#Bestand) + sum({$<#Date = {'$(=max(#Date))'}>}#Bestand))/2))*(52/(max(LfdNr) - min(LfdNr)))

];

do you want to see the macro?

[Sokkorn]

Hi MT,

Load all your formula like this;

Formeln:

LOAD * Inline [

    FormelName, Formel

    Umsatz Stk, sum(#Menge) - sum({$<LfdNr = {"=$(=min(LfdNr))"}>} [#Menge])

    ];

Your expression should be =$(Formel)

Did you try this yet?

Regards,

Sokkorn

[#8]

sum(#Menge) - sum({$<LfdNr = {=(=min(LfdNr))}>}#Menge) this seems to work and

sum(#Menge) - sum({$<LfdNr = {(=min(LfdNr))}>}#Menge) that too. but now i have the problem that my chart is not beeing built

[Sokkorn]

Hi MT,

What dimension and expression you used? It would be great, if you can share your app.

Regards,

Sokkorn

[#10]

i think it is too big to share. if i use this expression directly in the chart it works fine but if im trying it dynamicly there are problems