Condition in Set doesn´t work

[#1]

Hello,

I have these two calculations in a chart, see below.

Why is also values lower than  3000000 counted ?

=Sum{$<$(vSetPreviousMonth),Segment={"Glas"}>} [DebPris] )   for raw

=Count({$<$(vSetPreviousMonth),Segment={"Glas"},[KundNr]={"=Sum([DebPris]) > 3000000"} >} [KundNr])  for Prev mon sum>

kindly

Håkan

[Gysbert_Wassenaar]

Probably because the sum in =Sum([DebPris]) > 3000000"} > doesn't have the same set modifiers.

Try:

=Count({$<$(vSetPreviousMonth),Segment={"Glas"},[KundNr]={"=Sum({<$(vSetPreviousMonth),Segment={"Glas"}>}[DebPris]) > 3000000"} >} [KundNr])

[#3]

Hello again,

I tried this but now is there no answer at all, I only get - in all cells.

I added an test app for this.

Håkan

[#4]

Hello,

I solved the problem with help from Gysbert, but I had to change the " to ' or [ in the dimension.

I cannot find out the difference between these three ways to do it.

kindly

Håkan

[Gysbert_Wassenaar]

Ah, yeah. Blindly copy-pasting again. The problem was that there were nested "" pairs. So one of the pair had to be changed to single quotes or a pair of square braces or back ticks ```.