Formula to Find Amount Based on Multiple Criteria

[Mike_at_CG]

Hi Alteryx Community

Wondering if someone can help me with the below formula / issue?

I am trying to solve for par amount of a security based on having the value I want, price, coupon % and days of interest.

Example below.

PAR AMOUNT	PRICE	COUPON	DAYS OF INTEREST		Value I need
X	0.997	1.88%	150		6,000,000.00

I have price, coupon, days of interest and the value I need and am trying to solve for X.

My current formula is (Par Amount X Price)+(Coupon / 365) X Days of Interest.

Based on playing with the numbers I get to 6,020,469 and 6,020,470 par amount gets me very close but that is not really formulaic or automated.

Is there any way to accomplish this without a macro?  If not, can someone help with that as well?

Thank you all for your time.

Happy Holidays!

[alexnajm · Accepted solution]

I don’t understand, what’s the issue? Can you share your workflow with sample data?

[Mike_at_CG]

Think I figured it out.  Was missing a little bit after this part.  (Coupon / 365) X Days of Interest..

Thank you for looking at it though.