Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
I want to count number of transactions from registration date and one week further, for example:(DD/MM/YYYY)
client register in 01/01/2015, I want to count how many trans. he made until 07/01/2015.
thank you
Ilan
Hi,
Pls go through.
Consider that you have selected 03/12/2105
If you want 01/01/2015 to 03/12/2015, use
SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}>}Sales)
If you want min Date to 03/12/2015, use
SUM({< Year=, Quarter=, Month=, Week=, Date = {">=$(=Min({1}Date))<=$(=Max(Date))"}>}Sales)
You can transform a date into a numerical representation with the function Num(myDate), just add to your result the value 7, then simply count your transactions where transaction date is >= Num(DateStart) and <= Num(DateStart)+7
let me know
Try like:
Count({<MsaterCalDate={">=$(=Only(TransactionDate))<=$(=Date(Only(TransactionDate)+6, 'DD/MM/YYYY'))"}>}transaction)
Assuming your MasterCalDate would be of similar date format ( 'DD/MM/YYYY')