cancel
Showing results for
Did you mean:
Highlighted
Helper II

## Current Flow / Inflow / Outflow

Hello Everyone,

I would need your support for the calculations of the below metrics.

For every week (Monday to Sunday - column WeekNb), I need to determine:

- Current Flow: the number of records of the first day of the week - Monday;

- Inflow: the number of new records that appeared during that week, starting Tuesday. We can have cases when a record was present the other day for the first time, dissapears today and appears again tomorrow. In this case, the Inflow for that record is 2.

- Outflow: the number of records that dissapeared during that week. For this, we need to compare every record, day by day, next Monday included, to see if they are still present. We can have cases when a record dissapeared the other day, appears today and dissapears tomorrow. In this case, the Outflow for that record should be 2.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III

## Re: Current Flow / Inflow / Outflow

Hi

If you agree that these 2 "Inflows" aren't correct, given the current data, then the attached file should contain what you need.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

5 REPLIES 5
Highlighted
Super User III

## Re: Current Flow / Inflow / Outflow

please paste sample data of the input and desired output. Thanks.

These links might help as well:

and

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Highlighted
Helper II

## Re: Current Flow / Inflow / Outflow

Hi @ImkeF ,

I am sorry, but I do not have the option to attach the excel file.

For the Week no. 7, results for the below sample are:

CurrentFlow = 2
Inflow = 5
Outflow = 3

 WeekNb Record Day of the week Mentions Mentions 7 1001859 Monday CurrentFlow 7 1001522 Monday CurrentFlow 7 1001859 Tuesday No Inflow/No Outflow 7 1001522 Tuesday No Inflow/No Outflow 7 1001859 Wednesday No Inflow/No Outflow 7 1001522 Wednesday No Inflow/No Outflow 7 1132222 Wednesday Inflow (new record in that week,since yesterday) 7 1001859 Thursday Inflow (new record in that week,since yesterday) Outflow -one record missing - 1001522 7 1132222 Thursday No Inflow/No Outflow 7 1324433 Thursday Inflow (new record in that week,since yesterday) 7 1001859 Friday No Inflow/No Outflow 7 1132222 Friday No Inflow/No Outflow 7 1324433 Friday No Inflow/No Outflow 7 1001859 Saturday No Inflow/No Outflow 7 1132222 Saturday No Inflow/No Outflow 7 1324433 Saturday No Inflow/No Outflow 7 1333224 Saturday Inflow (new record in that week,since yesterday) 7 1001859 Sunday No Inflow/No Outflow 7 1132222 Sunday No Inflow/No Outflow 7 1324433 Sunday No Inflow/No Outflow 7 1333224 Sunday No Inflow/No Outflow 7 1001859 Sunday Inflow (new record in that week,since yesterday) 8 1132222 Monday No Inflow/No Outflow Outflow -one record missing - 1333224 8 1324433 Monday No Inflow/No Outflow Outflow -one record missing - 1001859 8 1423224 Monday No Inflow/No Outflow. Even if it is a new record, due to the fact it is in the next week, we don't taking into consideration for the Outflow

Highlighted
Super User III

## Re: Current Flow / Inflow / Outflow

Hi

If you agree that these 2 "Inflows" aren't correct, given the current data, then the attached file should contain what you need.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Highlighted
Super User IV

## Re: Current Flow / Inflow / Outflow

@Melisa123 Does the above reply helps. if you need more help make me @

My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User III

## Re: Current Flow / Inflow / Outflow

I hope it goes without saying that if my solution above doesn't work for you, I'm happy to adjust to meet your needs.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Announcements

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

#### Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors