Hi,
we use graphical calculation views for our data model. how can you get the end date if you only have startdate.
example:
Product_1 | 3000 | 01.01.2018
Product_1 | 3000 | 01.05.2018
Product_1 | 1000 | 01.07.2018
Product_2 | 1000 | 01.02.2018
Expecting result:
Product_1 | 3000 | 01.01.2018 | 01.05.2018
Product_1 | 1000 | 01.07.2018 | 31.12.9999
Product_2 | 1000 | 01.02.2018 | 31.12.9999
Thank you
Hi,
Refer to link below:
Lead/lag functions give you preceding or subsequent records when ordered by required fields. In your case, you can easily get "next" from date using this function. Subtract 1 from this value to get "to date".
Hope that helps.
Thanks,
Anup
Hi,
Thank you. But we are using graphical calculation views. Is this even possible to use in a graphical calc view?
Yes, you can create a table function and write SQL script there.
Table functions can be used in graphical calculation views just like ordinary tables.
Thank you. Works perfect :)