Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 fields SalesID,CSRID
SalesID will have all the CSRID as well as some unique SalesID.
when I make a selection in SalesId the corresponding values in CSRID are selected.
Is there a way to write an expression such that no matter what SalesID I Choose it will work only on values of csr and ims iD.
count({$<SalesID=,>}{$<CSRid=p(SalesID)>} if(CSRid=SalesID, 'some value'))
So here what I want is if in the current selection in csrid is in salesId the if that is equal to salesid then count some value.
Even if I select SalesID first then the corresponding CSRID it should neglect the current selected SalesID value.
Regards,
Try this?
= Sum(Aggr(Count({$< CSRid = p(SalesID), SalesID= >} if(CSRid = SalesID, 1)), CSRid))
No,
It is not doing the sum.
Regards,
Try this?
= Count({$< CSRid = p(SalesID), SalesID= >} if(CSRid = SalesID, 1))
If not can you share your expected output with a sample file here?