HANA calculation

[sk_kamaruzzaman]

previous-data.png

Hi All,

I want to populate new column based of sales different / day difference.

8/8/2016 - 7/30/2017 = 356 day

sales different in two year.

Day difference between two dates.

new field = sales different in two year / Day difference between two dates *365

Regards,

Kamruz

[pfefferf]

Please can you add some more details to your question instead of just posting your spec dump?

How you wanna do that (e.g. with an SQL Script, via an XS Classic/XS Advanced application ...)?

What have you tried so far, what issues you get?

...

Regards,
Florian

[sk_kamaruzzaman]

Hi,

Thanks for the reply

I used Window Function LEAD and got solved. Closing this thread.

Regards,

Kamruz