Dear all,
I have used an expression to display stores for which data is not sync as follows:
In a straight table i have used this expression to display stores for which data is not sync where my dimension is "Site"
if(num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))<15,
Date(Today()-1,'DD/MM/YYYY')))
-num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))<15,
MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE)))>0,
num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))<15,
Date(Today()-1,'DD/MM/YYYY')))
-num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,@_FinFullYear=,@_TABLE={'T1'}>}%_TARNDATE))<15,
MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))))
This expression is working fine
now in a text object I want to count this stores:
count of stores where this condition is applied.
Please help.