Different Result for same expression in TextObject and Chart

[phil-ebm]

Hallo Community

I have a problem and at the moment no more ideas how I can solve it or where/what the real problem is.

I use following expression in a text object and in a straight table:

=Count({<$(=vSetAnalysisPosTyp1)>} HU)

text object -> this is the right result

straight table

But at the end i have for the same selection two different results

I hope someone can help me.

Why I get different results for the same expression? How I can find the right result in the straight table.

Regards

Philipp

[MayilVahanan]

HI

Could you please post a sample file to verify the expression.

[marcus_sommer]

The reason will be that your expression within the table will be consider their dimension while within the textbox it will be calculated globally. In your case I assume that you used dimensions which are from more then one table and which are not be associated in the right way so that the table-dimensions are blown up.

- Marcus

[phil-ebm]

Here the example

[MayilVahanan]

Hi

In text box, your expression is

=Count({<$(=vSetAnalysisPosTyp1)>} distinct HU)

And your chart expression is

=Count({<$(=vSetAnalysisPosTyp1)>}  HU).

So please change the chart expression  to

=Count({<$(=vSetAnalysisPosTyp1)>} distinct HU)

Geschäftsjahr	Monat	Gesamt HU
		32636
2016	Jun	32636

[PrashantSangle]

Hi,

You are missing Distinct Keyword in chart expression.

Regards

[phil-ebm]

sorry in the example i added the wrong text object.

in this new file is the text object without distinct and less hus then in the straight table

[MayilVahanan]

Hi

Instead of HU , try like below in chart

=Count({<$(=vSetAnalysisPosTyp1)>}  [HU Pos])

Chart is calculates based on dimension like Year and Month. So there is duplication will occur.

Text box is calculate overall (without any dimension)

[#9]

Your expression is different in the chart and the text object,

In the expression in your chart,

add distinct to your expression,

i.e. =Count({<$(=vSetAnalysisPosTyp1)>} distinct HU)

Regards,

Anjali Gupta

[phil-ebm]

but i need the HU-Field not the HU Pos Field