calculate the excel formal in Alteryx.

Question

Hi team,

i have attached the image with formula. the formula i wrote to explain you the values, but in real file its calculated through the cell number. Instead of cell number i mentioned the field which formula is using. Please let me know how to calculate the formula in Alteryx. You can use the mentioned values in PM(Previous Month and Actual values.

Red color: Variable cost fields and Values

Blue: Rate fields and values

yellow: Factor fields and Values.

Please let me know if you have any questions in the formula. I want the results of each row. Suppose if you see Factor Limestone so i mention the formula in front of that row in the formula field and so on. Please need help on this.

Best Regards,

Kaustubh

Kaustubh17 · Answer

Hi @Raj

Please find the attached excel which have input and output sheet.

i want to calculate the variance formula which is calculated between Two month or may be between two FY or Between Two quarter.

output will be same as input just want to add the variance field in which it is calculated through the values in the data.

Note: PM = Previous Month and Actual is the current month.so the formula should work on all the months, all the FY and Quarter.

Please let me know if you have any questions.

Best Regards,

Kaustubh

Excel  Formula replicate in Alteryx.xlsx

Raj · Answer

@Kaustubh17 
will you bale able to add sample input and expected output
will be in better position to help.

Kaustubh17 · Answer

HI @Ace team,

Looking for some help on the above Question

Best Regards,

Kaustubh