Substitute actual month values with previous month ones

Hello everyone,

I'm struggling with this situation:

I would need a function that substitute only the current month (ex. in this case 2020-10) values in column E (in this case -496,569) with the previous month value(-2627,35).

If the date is not this month, just give me the value in E column.

Thanks a lot in advance for your help!

Matteo

Expression

Accepted answers

atcodedog05

Hi @MatteoMalchiodi

I got your point your claim is what if the previous month is missing.

I have modified the workflow according to it.

Output:

In this demo output i have removed all 2020-09 so value for 2020-10 is 0

You can check and let me know 🙂

prev month.yxmd

All comments

atcodedog05

Hi @MatteoMalchiodi

Can you quickly provide this sample data. It can be solve with multi-row formula tool.

atcodedog05

Hi @MatteoMalchiodi

Here is a workflow for the task.

Input:

Output:

Workflow:

If you provide sample data i build a workflow for it too.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

prev month.yxmd

MatteoMalchiodi

Yes of course,

please find attached a sample data of this database

Data sample.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703