Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Currently I have a variable formula =num($(eRSFPerTotalAttorneys), '#,##0') that says....
give me the size of all locations and divide it by the number of all attorneys for all locations. Here is the set analysis I have set for this Variable...
SET eRSFPerTotalAttorneys = $(eRSF) / $(eTotalAttorneys);
SET eRSF = 'sum(Size)';
SET eTotalAttorneys = 'sum([Total Number of Attorneys])';
Can someone please help me modify the Set analysis to exclude Beijing and Shanghai locations?
I tried this but it comes up as blank ...
SET eRSFPerTotalAttorneyss = $(eRSFF) / $(eTotalAttorneyss);
SET eRSFF = 'sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>}(Size)'; //without Asia
SET eTotalAttorneyss = 'sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>} [Total Number of Attorneys]) '; //without Asia
When I don't try to exclude anything, it populates as 6408, but when I try to exclude these locations, it comes up blank
I see a possible issue
SET eRSFF = sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>}Size);
and it will be better if you don't use quotes outside or use double quotes (should work with set if I am not wrong)
I see a possible issue
SET eRSFF = sum({<City-={'Beijing', 'Shanghai', 'Taipei'}>}Size);
and it will be better if you don't use quotes outside or use double quotes (should work with set if I am not wrong)