Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
=num(count({<CompanyID ={'$(v_Currently_Selected_CustomerID)'}>}distinct Sales_Records),'#,##0')
As can be seen in the above, I am trying to use set analysis to count
Sales Records
Where the CompanyID is the same value as the CUSTOMERID (stored via a variable).
I think this syntax is incorrect. Any help most appreciated.
H
It looks good to be. What error are you getting? Remove the num() function first and let me know if it works
Hi
Could you use an expression like this?
=if(CompanyID=GetFieldSelections(v_Currently_Selected_CustomerID), num(count(distinct Sales_Records),'#,##0'),)
This format will require you to always have a CustomerID field selected... but it should work fine..
good luck.