Dear ZZ

What about the calculation field ?

How should i do it?

Thanks

Dear ZZ

Thank you very much!

Dear ZZ

May I know if i want the % of daily differences of the sales, where the calculation field is something like that as below:

(TODAY-PREVIOUS DAY)/ PREVIOUS DAY

How should i achieve it?

Dear ZZ

Thanks a lot !

Allow me to state the steps out Could u please check is it correct?

1.  Create 2 parameters

2. Create 3 Calculation Fields

I have tried on it...but looks like no reaction...and I dont know the variance and current date calculation field...

Dear ZZ

One more question...if i want to do only the default? (no customized date)

Means only show the data for today and the data for differences of the previous day.

Thanks

Dear ZZ

I noticed that if I have a missing day...the variance wont perform..

May i know how to make it to compare toward the previous available day?

For eg :

If TODAY is 26/6, the differences shown should be (500-1000)/1000

Thanks

Dear ZZ

for the 'sales cal' calculation field

The highlighted field cannot be in a calculation?  for ((eg a/2)/b)

Thanks

Dear ZZ

Referring to the sales cal and variance calculation field....may i know how to amend it if wanted the null to become 0?

for the sales cal i am able to do it as below...but the variance i cant

ZN(lookup(sum(IF [Date] = [DateLbl] THEN [Sales] END),0))

May i know how to do it?