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