4 Replies Latest reply: Mar 13, 2015 7:51 AM by Gysbert Wassenaar

# Condition in Set doesn´t work

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

• ###### Re: Condition in Set doesn´t work

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])

• ###### Re: Condition in Set doesn´t work

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

• ###### Re: Condition in Set doesn´t work

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

• ###### Re: Condition in Set doesn´t work

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 ```.