Identifying latest 12 months from date column

Hi @Sharathkrishnan

A corrected version of the workflow.

Status 2.yxmd

I will reply to your direct message propably tomorrow.

Regarding the workflow, I forgot to include only the data that have 0 as a sales value for the year. Previously it set the status for off for each position in the newest year.

All comments

Can you show expected input and expected output?

Hi Emil,

Kurohits

Hi,

I have created a solution as per your inputs shared. Checkout my solution and let me know if it is feasible for you. if not, then share the desired output. If it is as per your requirement, then please accept it as solution.

Date Time Solution.yxmd

What I am doing here is identifying the max year for each of the product. If max year sales are 0 I am populating status off.

Status.yxmd

Here for some records even when sales values are present status is 'off'.Can you help me with it

Copy of Status.yxmd

data.xlsx

Hi @Sharathkrishnan

A corrected version of the workflow.

Status 2.yxmd

Hi Emil,

Can you please tell me what was wrong in the previous version ? I am not able to figure it out..

I will reply to your direct message propably tomorrow.

Regarding the workflow, I forgot to include only the data that have 0 as a sales value for the year. Previously it set the status for off for each position in the newest year.