Logic help

[Anonymous]

Greetings ,

Can you pls help in following logic.

how to count Number of Trading Customers = Distinct count of customer if last transaction is within date prompt/filter criteria.  If no date filter is selected then criteria is YTD start date and end date.

Regards

Adarsh

[Anonymous]

something like if getselectedcount(<your field>)>0,count(Distinct Customers),count(<Year=2017>Customers) ??

[Anil_Babu_Samineni]

May be this?

If(GetSelectedCount(datefieldname)>0, Count({<datefieldname = {">= $(=YearStart(datefieldname)) <= $(=Max(datefieldname ))"}>}Customers), Count(DISTINCT Customers))