Multiple Ageing Bracket and Percentage

Hi Community,

I have the data which consist of multiple ageing bracket criteria and percentage for each item as per screenshot below. Each group of data and type consist of different ageing bracket and percentage .

I would like to use the above criteria to calculate ageing months and discount for the following data as per screenshot below.

And the result will be as follow:

May i know if there is anyway to build the workflow more dynamically based on the criteria - Data A? I had attached the desired result in the excel file below.

Multiple type and ageing bracket.xlsx

Common Use Cases

Accepted answers

AngelosPachis

Hi @SH_94 ,

At which stage are you at in terms of building the workflow? Is there any particular point that you got stuck?

I have created a workflow that answers your question, but the purpose of the community is to help you in points you get stuck, not just do things for you although that's very nice and convenient.

I would suggest you try building this yourself by looking at the tools used and if you get stuck then use the solution. In this way, you will better understand the logic behind it and what the tools do or why those tools have been chosen.

Let me know if you have any questions on the workflow.

Cheers,

Angelos

example.yxmd

All comments

AngelosPachis

Hi @SH_94 ,

At which stage are you at in terms of building the workflow? Is there any particular point that you got stuck?

I have created a workflow that answers your question, but the purpose of the community is to help you in points you get stuck, not just do things for you although that's very nice and convenient.

Let me know if you have any questions on the workflow.

Cheers,

Angelos

example.yxmd

SH_94

Hi @AngelosPachis ,

Thank you for the prompt response.

I have build the workflow as per screenshot below but i feel like it is time consuming for me to split one by one as per screenshot below. My original data have around 15 criteria which i think it is not so dynamic if i build in this way. Hence, i would like to ask for assistance if there is more fastest or dynamic way to build the workflow so that if my original keep increasing the criteria , i would not need to build the workflow so long and rigid.

Currently i still digesting on how you build the workflow and let you know if i encounter anything.

Thanks again for the sharing of the workflow. Appreciate it a lot.

SH_94

Hi @AngelosPachis ,

May i know how u able to convert the data from excel into the text input ? Is it we need to do it manually or we can do it fastest way?

Thank you

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335