topic Re: Last Year Same Day Sales in App Development

Last Year Same Day Sales

madnanansari — Sat, 17 Dec 2016 06:23:17 GMT

I am trying to create a table with the below information:

Date, Sales, Sales (Last Year Same Day)

01/12/2016, 50, 21

02/12/2016, 23, 21

for Sales (Last Year Same Day) I am trying the below formula:

Sum(

[Date]={$=(Max([Date])-364)}

Sales

)

This is just bringing '0'. I tried lot of options but it don't work at all.

Any help?

Re: Last Year Same Day Sales

shraddha_g — Sat, 17 Dec 2016 06:42:12 GMT

Try

Sum(

[Date]={"$(=date(addyears(Max([Date]),-1)))" }

Sales

)

Re: Last Year Same Day Sales

MK_QSL — Sat, 17 Dec 2016 11:00:00 GMT

SUM({<YourDateField = {'$(=Date(AddYears(Max(YourDateField),-1))'}>}Sales)

Re: Last Year Same Day Sales

madnanansari — Sun, 18 Dec 2016 12:07:10 GMT

this works fine when there is no master calendar. Once I use one; it shows zero values then.

Master calendar has other columns as well like Quarter, Year, Month etc along with Date.

Re: Last Year Same Day Sales

Anonymous — Sun, 18 Dec 2016 14:42:57 GMT

Hello Mohammad,

you don't want to use.. -364 like this...

we have a...calendar functions like...addyears and addmonths to play on date fields.

Try your expression like this...

sum({<Your Date filed={$(=AddYears(Today(),-1))}>}[Final Price])

sum({<Your Date Field={$(=AddYears(Max(YourDateField),-1))}>}[Final Price])

Re: Last Year Same Day Sales

madnanansari — Sun, 18 Dec 2016 15:17:53 GMT

I tried as you suggested and it shows zero.

Re: Last Year Same Day Sales

shraddha_g — Mon, 19 Dec 2016 04:22:48 GMT

If possible share sample app

Re: Last Year Same Day Sales

madnanansari — Mon, 19 Dec 2016 09:28:30 GMT

I have designed a sample App. How to share it here?

Re: Last Year Same Day Sales

shraddha_g — Mon, 19 Dec 2016 09:40:49 GMT

click on Reply - > Use Advanced Editor on top right corner - > attach at bottom right corner

Re: Last Year Same Day Sales

madnanansari — Mon, 19 Dec 2016 10:06:14 GMT

Pls. find the sample app. The only sheet shows a filter of Month and the table shows day wise sales for each day of the month.

Re: Last Year Same Day Sales

madnanansari — Mon, 19 Dec 2016 10:13:48 GMT

pls. find attach the data files (QVD) for the sample data as well.

Re: Last Year Same Day Sales

shraddha_g — Mon, 19 Dec 2016 10:26:44 GMT

PFA..

Worked with LastYTDflag.

Re: Last Year Same Day Sales

madnanansari — Mon, 19 Dec 2016 10:30:17 GMT

I need Sales for Last Year Same day that is 01-Dec-2016 is thursday, so I need sales on thursday last december which is 03-Dec-2015.

The below is the formula;

Sum(

[Date]={$=(Max([Date])-364)}

Sales

)

but as explained its not working. I dont need last year same date sales.

Re: Last Year Same Day Sales

shraddha_g — Mon, 19 Dec 2016 10:36:36 GMT

Calculate WeekDay , Week , Year in master calendar by using

weekday(Date) as WeekDay,

week(Date) as Week,

Year(Date) as Year

expression as

sum( { < WeekDay = {"$(= weekday( max(Date)))"} , Week = {"$(=week(max(Date)))"}, Year = {"$(=year(Max(Date))-1)"} > } Sales )

Re: Last Year Same Day Sales

madnanansari — Mon, 19 Dec 2016 10:39:50 GMT

I dont need last year same date sales but if this is also working then my job is over.

Select Nov-2016 and see whether the results are appearing?

Last Year Same Day Sales

Re: Last Year Same Day Sales

shraddha_g — Mon, 19 Dec 2016 10:44:19 GMT

sum( { < WeekDay = {"$(= weekday( max(Date)))"} , Week = {"$(=week(max(Date)))"}, Year = {"$(=year(Max(Date))-1)"} > } Sales )

this expression will consider weekday as Mon,Tue, etc to compare with last year

Re: Last Year Same Day Sales

madnanansari — Tue, 20 Dec 2016 05:35:36 GMT

Formula seems to be correct but its not working. U have the test application; can u try on that?

Re: Last Year Same Day Sales

shraddha_g — Tue, 20 Dec 2016 05:47:21 GMT

can you send the one you tried with this expression?

Re: Last Year Same Day Sales

madnanansari — Tue, 20 Dec 2016 05:49:46 GMT

its the same i uploaded here before

Re: Last Year Same Day Sales

madnanansari — Tue, 20 Dec 2016 07:16:56 GMT

pls. find attached the app i tried with,