count - formula

[#1]

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

[SunilChauhan]

u  can write like this

Count( if(Datefiled=$(vTodaydate),SalesOrderid)/count(distinct total <dateTimeshipping>if(datefield=$(VToDayDate)salesorderid)

thanks

Sunil Chauhan

[#3]

Thanks Sunil!

[#4]

it's not working

I have this:

Count(if(Year=$(vCurrentYear),SalesOrderID)/Count(distinct total(if(Year=$(vCurrentYear),<DayTimeShiping>SalesOrderID))

[SunilChauhan]

can u share sample

[#6]

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....