Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have to do a set analysis . The format is like below.
Sum({<FM= {MSL}, [Task Name] = {EExternal SL Engagment - SL interaction}>}[$(vTotalyrshours)])/Sum({<FM= {ML}>}[$(vTotalyrshours)])
$(vTotalyrshours) is sum(Q1hours)+sum(Q2hours)+sum(Q3hours). Please suggest how to do it . I am not getting any values in it.
Thanks,
Niha
Try this
Pretending MSL and ML are texts not fields
=(sum({<FM= {'MSL'}, [Task Name] = {"$(=(EExternal SL Engagment - SL interaction))"}>}Q1hours)+sum({<FM= {'MSL'}, [Task Name] = {"$(=(EExternal SL Engagment - SL interaction))"}>}Q2hours)+sum({<FM= {'MSL'}, [Task Name] = {"$(=(EExternal SL Engagment - SL interaction))"}>}Q3hours))
/
(sum({<FM= {'ML'}>}Q1hours)+sum({<FM= {'ML'}>}Q2hours)+sum({<FM= {'ML'}>}Q3hours))
Try this
Pretending MSL and ML are texts not fields
=(sum({<FM= {'MSL'}, [Task Name] = {"$(=(EExternal SL Engagment - SL interaction))"}>}Q1hours)+sum({<FM= {'MSL'}, [Task Name] = {"$(=(EExternal SL Engagment - SL interaction))"}>}Q2hours)+sum({<FM= {'MSL'}, [Task Name] = {"$(=(EExternal SL Engagment - SL interaction))"}>}Q3hours))
/
(sum({<FM= {'ML'}>}Q1hours)+sum({<FM= {'ML'}>}Q2hours)+sum({<FM= {'ML'}>}Q3hours))
HI,
Thanks. Sorry my typo error. MSL only and all are value of a column . I followed your suggestion the codes looks like below. It is working
=(sum({<FM ={'MSL'}, [Task Name] = {'EExternal SL Engagment - SL interaction'}>}Q1hours)+sum({< FM ={'MSL'},
[Task Name] = {'EExternal SL Engagment - SL interaction'}>}Q2hours)+ sum({<FM ={'MSL'},[Task Name] = {'EExternal SL Engagment - SL interaction'}>}Q3hours))
/
(sum({<FM ={'MSL'}>}Q1hours)+sum({< FM ={'MSL'}>}Q2hours)+sum({<FM ={'MSL'}>}Q3hours))
But I was wondering instead of trying for all quarters if it is possible to do by a variables. but I think it is not a good way. Thanks.
Niha