Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a table like below
product,date, price
apple iphone ,1/1/2019,30000
one plus,5/1/2019,35000
apple iphone ,15/1/2019,40000
my requirement here is as explained as below in scenarios
scenario 1:
in calendar object if i select 2/1/2019 the straight table should show [product apple] and [price of apple] [(i.e. 30000) --- latest price at 2/1/2019]
scenario 2:
and if i select 10/1/2019 the table should show [product apple and onplus ]and price of the both [i.e. 30000 and 35000].------- latest price at 10/1/2019
scenario 3:
and if i select 20/1/2019 the table should show [one plus and apple ] and price of both [i.e. 35000 and 40000] --- because the latest price at the time of 20/1/2019 for apple and one plus was 35000 and 40000 respectively .
finally if i select any particular date in a calendar object the table should show latest prices of product .
thanks in advance
thanks
siva
Hi Siva,
Assuming you have a master calendar table setup to select any dates for which you want to see the data.
I stored the date selection in a variable and then used the below set expression to display my values.
MAX({<DATE = {'<=$(=vdateselect)'}>}PRICE)
Hope this helps.
Regards,
Siddhesh H Mane.