Multiple alternate states within a bookmark

Mt3 — Wed, 09 Feb 2022 13:42:43 GMT

Hi,

I was wondering if any of you have assinged 2 or more alternate states to a bookmark selection in set analysis?

I have tried below and result are following:

sum({1-[Group 1]::BM01} Sales) - works fine

sum({1-[Group 1,Group2]::BM01} Sales) - does not bring any results

sum({1-([Group 1]+[Group2])::BM01} Sales) - does not bring any results

sum({[Group 1][Group2]::BM01} Sales) - does not bring any results

Also, do you think it would be possible to add multiple bookmarks, to the selection? Exemplary:

sum({1-(([Group 1,Group2]::BM01) + ([Group 1,Group2]::BM02) )} Sales)

I have checked that sum({1-(([Group 1]::BM01) + ([Group2]::BM02) )} Sales) gives a result but skewed in numbers.

Re: Multiple alternate states within a bookmark

chris_djih — Wed, 09 Feb 2022 13:53:24 GMT

i would guess you have to do the operations the other way around:

try something like this: sum({1-([Group 1]::BM01+[Group2]::BM01)} Sales)