Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have created one text object with this expression:
=Sum(Aggr(Sum(DISTINCT {<HIERARCHY_SELECT=,Recruiter = {'Irfan Memon', 'Rajiv Ranjan', 'Aditi Saxena', 'Sneha Singh'}, JobClassid = {4}, Date_Flag={'EnterDate'}>} NoOpenings), jobid))
In this HIERARCHY_SELECT is my list box.
I want exclude HIERARCHY_SELECT list box selection to my text object that's why i created like this. But whenever i am selecting the values in my HIERARCHY_SELECT list box those selections are applying to that text object also
What is the wrong with my expression. I am not getting
Can you guys please help me out to achieve this
Thank you in advance
Try like:
=Sum({<HIERARCHY_SELECT>} Aggr({<HIERARCHY_SELECT>} Sum(DISTINCT {<HIERARCHY_SELECT=,Recruiter = {'Irfan Memon', 'Rajiv Ranjan', 'Aditi Saxena', 'Sneha Singh'}, JobClassid = {4}, Date_Flag={'EnterDate'}>} NoOpenings), jobid))
Try like:
=Sum({<HIERARCHY_SELECT>} Aggr({<HIERARCHY_SELECT>} Sum(DISTINCT {<HIERARCHY_SELECT=,Recruiter = {'Irfan Memon', 'Rajiv Ranjan', 'Aditi Saxena', 'Sneha Singh'}, JobClassid = {4}, Date_Flag={'EnterDate'}>} NoOpenings), jobid))
HI Tresesco,
It's working fine. I have one more expression
=fabs(Interval{<HIERARCHY_SELECT=>}EnterDate - Today(),'d') ------ it is showing error in expression
Can you please modify this also
Try like:
fabs(Interval ( Only({<HIERARCHY_SELECT=>} EnterDate) - Today(),'d'))
The Aggr() dimension value respect the selections, so you need to have the Aggr() inside an override of the current selections that affect the Aggr(). This is basically what Tresesco's solution does, although Ithink the second override is unnecessary:
Sum({<HIERARCHY_SELECT>} Aggr({Sum(DISTINCT {<HIERARCHY_SELECT, Recruiter = {'Irfan Memon', 'Rajiv Ranjan', 'Aditi Saxena', 'Sneha Singh'}, JobClassid = {4}, Date_Flag={'EnterDate'}>} NoOpenings), jobid))
Hi Tresesco,
It's not working
Hi Jonathan,
Sorry to say this... It's not working. It is giving error.
Tresesco's solution is working fine
Stray {
Sum({<HIERARCHY_SELECT>} Aggr(Sum(DISTINCT {<HIERARCHY_SELECT, Recruiter = {'Irfan Memon', 'Rajiv Ranjan', 'Aditi Saxena', 'Sneha Singh'}, JobClassid = {4}, Date_Flag={'EnterDate'}>} NoOpenings), jobid))