Daily Sales

[#1]

Hi;

I created a variable to see current day sales amount. However that does not work well.

My Variable formula : currentyear = 2011

                                current day = 8/2/2011

And then my expression is as follows :

sum({<sts_Fatura_Yil={"<=$(currentyear)"},sts_Fatura_Tarihi={"<=$(currentday)"}>}sts_miktar)

sts_Fatura_Yil  shows year of sales; sts_Fatura_Tarihi shows date of sale and sts_miktar is sale amount. All of them are Field.

I would like to see sale amount at the last date. (Namely current date)

Everymorning I prepare sale report.  When I change the variable and make it today/current day; I would like to sale of current day.  Forexample today is 8/3/2011. Tomorrow when I change variable (current day variable) and make it 8/4/2011 I would like to see only sale amount of 8/4/2011 as a daily.

Although I was triyng to find right expression I couldn't get anything. Is there anyone to help me please ?

Thanks in advance

Mustafa

[#2]

Hello Mustafa,

as I don't know what is in your variable "currentday" here a adopted code snippet that works in one of my apps. Perhaps you can compare it with your "currentday".

sum( {<   . . .    sts_Fatura_Tarihi= {"<=$(=date(today()))"} >} sts_miktar)

HtH

Roland

[#3]

Dear Rolan,

Thanks for your kindly help.  I will try to adopt your expression.

Take care

Mustafa