date functionality

[sakshikaul]

Hi,

I have a query, I want to compare the sales for a current year with sales 10 days prior to current year

Here in the below image when user selects an event , corresponding date for that particular event and corresponding days for comparison 

for eg as shown in below image users select event as Diwali, date as 10/10/2018

no of days for comparison =9

so Date selected for comparing is calculated based on following 

Date selected by user(10/10/2018 )- no of days for comparison (9) so  'Date selected for comparison '=1/10/2018 

so now I have to compare between the given range last year date ie 1/10/2018  and current year date 10/10/2018,

so this is working fine only if I am selecting no of days for  comparison as 1,2,3,4,5,6,7,8,9 but if I am selecting  no of comparison days as 10 then its not working  because here date selected for comparison will be 30/09/2018 so this means here the month will be changed .

This is working fine

this is not working fine

[pradosh_thakur]

did you select anything on last date? If you select i don't see why the expression should not work as expected.

[sakshikaul]

yes I selected lastdate and then wrote this expression in the text box

 =$(Date(max(lastDate)- compday)

[pradosh_thakur]

Did you try the expression i asked you to write initially

=sum({< Sold_Date = {"<=$(=max(Sold_date)) >=$(adddays(max(Sold_date),-compday))"}>} quantity_sold)

 

 alter the entire expression accordingly

[sakshikaul]

Hi,

The following expression is working fine 

=Date(max(lastDate)- compday)

[sakshikaul]

Hi 

I dont want maximum date, Rather I want whichever date user will select from given list box (Date), say suppose 10/10/2018 and user selects days of comparison as 3

10/10/2018 -3 = 07/10/2018

then the sales for 07/10/2018 should get displayed 

[shiveshsingh]

@pradosh_thakur  - My bad 😞 

Greater than and less than sign was not placed correctly

[shiveshsingh]

sum({< Sold_Date = {"<=$(=max(Date))>=$(=Date(max(date)- compday)"} >} quantity_sold)
- sum({< Sold_Date = {"<=$(=max(Date))>=$(=Date(max(date)- compday)"} >}quantity_returns)

Can you try this once?

When you'll select the date from list box which have Date Field, then max(Date ) will become the date which you selected and compday is the number of days which you'll select for comparison.

[sakshikaul]

Hi 

I have a query regarding a data model structure.

I have following inline table which contains the event dates ie start date and end date now I want when user selects the date range lets say 5/07/2018 to 10/10/2018 the corresponding sale for that particular period should be displayed so for that I want to link this inline table with the main table . so how can I do that?

Event:
load *

INLINE [

LastDate,currentDate, Event

 5/07/2018, 10/10/2018,Durga pooja

 10/09/2018,15/10/2018,Diwali

];