Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need the count of customer when user selects particular date in date filter.But if there is no date selected it will show data of ytd .
May be Try this in your expression?
= IF(GetselectedCount(Yourdatefield) = 0, Count(DISTINCT {< Year = {"= $(= Max(Year))" } >} Customer), Count(Distinct Customer) )
Hi,
Please refer to the attached sample app,
try like below,
if(GetCurrentSelections(Date),count(DISTINCT Barcode),
count({<CurrYTDFlag={'1'}>}DISTINCT Barcode))
Naga suggested fuction GetselectedCount works,
Refer to the attached sample,
= IF(GetselectedCount(OrderDate) > 0, Count(Distinct OrderID),Count(DISTINCT {< Year = {$(=Max(Year))}>} OrderID))
Thanks,Deva