Budget calculator

Can anyone tell me if theres a way to process a text value in a dropdown as a number so that a caculation can be performed?

Use case: I want to create a annual budget calculator which allows the users to input an expense then select either day, week, month or year from a dropdown which will populate a text box with the sum of the calculation e.g. the cost of fuel is $50 per week which means the user will enter $50 and select week from the dropdown. The calculation 50 × 52 weeks = $2600 will be run in the background.

Bases on the example you gave you can use Option Sets to these options (day, week, etc…) and a new attribute tied to them where you can insert the corresponding value.

1 Like