Expression is returning incorrect data

[jenv20032000x]

Hello Experts!

I'm very new to Alteryx and appreciate your time and attention to my question.  I have a flow that is summarized for total hours and from that a percentage is derived by dividing the total hours by each dept hours (See Pt2 attachment).  The summarized data derived is passed along to the detailed data.  The end result is attached (first attachment).  The field "Orig Hours Plan (Vol Adj)" should be multiplied by the "Mix".  On the first row of the data the calculation should be 28,989.79 * .0270 = 782.72 but you can see in the attached the result is 1,073,696.  The Pt2 attachment shows the summarized data that is joined to the details in the first attachment.  Lastly, an image of the flow is attached as well as an image of the formula used.  I don't know why the formula is incorrect.  I've checked the metadata and the numbers are all fixed decimals.  How can I get my calculation to work correctly?  I hope I've given you enough information to help me solve this problem.

[JosephSerpis · Accepted solution]

Hi @jenv20032000x don't you need to replace "/" with "*" if you want it to = 782.72 plus also you need to change the field type to a double not Int32. Also you might need a round function if you want it to 2 decmical places. 

[AbhilashR]

@jenv20032000x - attached is an implementation of @JosephSerpis's explanation. Hope this helps.

[jenv20032000x]

WOW, I'm embarrassed!  Thank you for the quick response.  Guess I should've just walked away from it and tried again tomorrow, probably would've seen it then.  Ugh.