Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys!
I need one help...
I have this Formula: Count(distinct SalesOrderID)/Count(distinct total <DayTimeShiping> SalesOrderID)
it's working correct, but I have to set up with a date, that means: my result should show with the current date of 30-June-2009, I have also on my Script: LET vTodayDate = num(MakeDate(2009,06,30)); //Today's Date
How can I put the Date in my formula? Have someone an idea?
Regards
Jenni
u can write like this
Count( if(Datefiled=$(vTodaydate),SalesOrderid)/count(distinct total <dateTimeshipping>if(datefield=$(VToDayDate)salesorderid)
thanks
Sunil Chauhan
Thanks Sunil!
it's not working
I have this:
Count(if(Year=$(vCurrentYear),SalesOrderID)/Count(distinct total(if(Year=$(vCurrentYear),<DayTimeShiping>SalesOrderID))
can u share sample
This is formula working, but it just show the current year of 2009,
Count({$<FinYear={$(=Max(FinYear))}>}distinct SalesOrderID)/Count({$<FinYear={$(=Max(FinYear))}>}distinct total <DayTimeShiping> SalesOrderID)
but with full Date--> Month(June), Year(2009) and Day(30), I cant do it with the Variable "vTodayDate"
I put a sample....