Determining Age Range based on Age Variable

kkreitzer · ‎06-25-2019

Hello all!

I am really stuck here and am hoping that someone can assist with my issue. I am working on migrating a workflow from SharePoint Designer that currently calculate the cost of life insurance for an employee. The insurance costs are based on the age range you fall into. I have already calculated the age successfully and have it saved stored in a variable called 'EmployeeAge'. Here is an example of the ranges:

Age Range	Rate
Under 25	0.09
25-29	0.08
30-34	0.09
35-39	0.11

If I have an employee that has an EmployeeAge of 28, I need the Rate variable to updated with .08.

Does anyone have an idea of how to accomplish this cleanly? I know of a formula in excel for this and was trying to figure out how to replicate this functionality and store the age range in a variable and then add a Switch to set the Rate variable.

=LOOKUP(B2,{0,"0-24";25,"25-29";30,"30-34"})

I appreciate the help!!

~Kayne

yashag2255 · ‎06-25-2019

Hi @kkreitzer

I have a long and dirty workaround for you that is easy to implement and undersatnd. You can create nested if conditions and manipulate variable values to get the appropriate rate. Please see the screenshots below and replicate:

I have an nteger variable that is the age and a float variable that is rate and using nested if condtion actions, i am setting the value of the rate variable.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

v-lin-msft · ‎06-27-2019

Hi @kkreitzer,

Currently, there is no function that can partition Numbers in flow like excel. You can refer to the following flow to establish three conditions, which can divide Age into different data segments, then you can set the rate according to the Age.