Calculation

[parvez933]

Hi Everyone,

I got a scenario where, I was supposed to calculate the date type from the date where it needs to be added.

Ex:

Load * inline [

Item,  DOP,  Day,  DOE

Milk1, 01/01/2018, 10

Milk2, 02/01/2018, 2

Milk3, 03/01/2018, 5

Milk4, 04/01/2018, 1

Milk5, 05/01/2018, 1

Milk6, 06/01/2018, 3

];

DOP: Date of Purchase, Days: Number of days the product will stay fresh/no of days to expire, DOE: Date of Expiry

Question:

I was supposed to use a straight table to display Item as dimension and DOE [by adding DOP + days]. Once I get the DOE, I have to sort the data according to DOE [The 1st product in the list is which to be expired first].

Please help me as I was not able to do so.

[Frank_Hartmann · Accepted solution]

Is this what you are trying to achieve?

[parvez933]

Hey Hi Frank!
Thank you for your response. This is the output I was expecting. It is working!

[Frank_Hartmann]

Happy to hear that.
If your Problem is solved please mark the answer as solution.

Have a nice Day

regards
Franky