Exponents - To the Power Of

Like (0) Share

Report

Posted on 17 Oct 2023 20:35:23 by wherdzik

I would like to use the PVA bot to forecast an increase wages over a period of time.

I would pass 3 variables:

Base Pay

Pay increase Percentage

and number of periods

So lets say if I want to estimate if a person was going to receive 3 percent in pay increases over the next 5 years what would they be at if they are current making $100,000.

=$100,000*(1.03)^5

Can I do this in flow and retrieve to PVA BOT. Is there a function for this?

Thank you.

Categories:

General

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 32,859 Most Valuable Professional on 30 Oct 2023 at 11:35:23

Like (1)

Report
Re: Exponents - To the Power Of

Hi @wherdzik,

Yes, that should be possible. @DamoBird365 has created a nice video on how to use xpath and xml for this type to the Power of calculation:

https://www.youtube.com/watch?v=Vmor6LwL4mY

Below is an PVA example which uses that same approach

1. Compose with Root xml

<root></root>

2. Select action

a. From field

range(0,triggerBody()['number_2'])

b. Map field (switched to text mode with button on the right)

add(div(float(triggerBody()['number_1']),100), 1.0)

3. Compose to calculate new forecast wage

mul(triggerBody()['number'],xpath(xml(outputs('Compose_-_RootXML')),join(body('Select'), '*')))

4. My PVA topic test run with your example data

Was this reply helpful? Yes No
wherdzik on 30 Oct 2023 at 17:17:07

Like (1)

Report

Re: Exponents - To the Power Of

Works wonderful. Thank you.

Was this reply helpful? Yes No