Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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])
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
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
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 ```.