Hi,
Say suppose today is Tuesday , I want to compare this Tuesday's count of data or percentage with last week Tuesday's data of the same month.
it should be dynamic,for tommorrow it should show last week wednesday's count or percentage of data.
Please can anyone give me the calculation formula.
Thank you.
2 answers
Hi Kumar,
Thank you for the reply.. the calculation formula is giving me different answer than what i expected.
I have used the following formula
IF datediff('day',[Report Date],today()-7)=1 THEN [Facebook Likes] END
which is meeting my requirement as of now
Thank you
