Calculation

[aparna0208]

Hi,

I wanted to know if there is a way in Alteryx to calculate increase in value?

Please see below input. Need to calculate 20% increase of the "field column". I tried this formula but not sure if its correct - Field*5/100

[Emil_Kos · Accepted solution]

Hi @aparna0208, I have prepared a workflow for you. The formula that you need is:

[Field]*1.2

The output:

[AngelosPachis · Accepted solution]

Hi @aparna0208 ,

Indeed you should use a formula tool, and if you only care about the increase then your formula is also correct.

If you want to estimate the values of your field after the increase, then you should do 

Field*1.2

so 20.65 with a 20% increase will yield 24.78

[KarolinaRoza · Accepted solution]

Hi @aparna0208 

I am not sure what you need to calculate.

If you need

- volume of 20% increase : then you can apply: [20% increase]=[field]*20/100

- increased volume by 20% then you can apply [increased value] = [field]*1.2 or [field]+[20% increase]

Regards,

Karolina

[aparna0208]

@KarolinaRoza @AngelosPachis @Emil_Kos It worked. Thanks much for all your inputs!