Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am stuck in a situation where I need to exclude some data with set analysis.
Please check attached QVW for more information.
Thanks,
Kamal
if(GetPossibleCount([service family])>1, sum(cost),
if([service family]='server',
sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>} cost),
sum(cost)
))
Thanks for the help... I am sorry I could not clear the situation..
If both the items (Mainframe and server) are selected I need to have sum of all mainframe items and those items of server where service category is not alredy there in mainframe..
i.e the sum of items which I see when I select mainframe and server items which I see when I select server.
Thanks,
To exclude use a minus equals -= syntax;
Field-={"Value"} Not equal
Field={"Value"} must equal
Or use E() as post above suggested.
if(GetPossibleCount([service family])>1,
sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>+<[service family]={mainframe}>} cost),
if([service family]='server',
sum({$ <[Service category]=E({$ <[service family]={mainframe}>} [Service category])>} cost),
sum(cost)
))