Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Dear Rolan,
Thanks for your kindly help. I will try to adopt your expression.
Take care
Mustafa