Formulas 🧮

What makes spreadsheets powerful? Formulas. You can manipulate data however you want.

Munyun works the same way.

What are metrics?

Metrics are the building blocks. They're basically labels for different types of data or calculations. Here are some examples:

1. "Total spending on groceries"

2. "Total income this year"

3. "0.05" (or 5%)

4. "Number of months in a quarter"

5. "Double my grocery spending plus transportation costs"

Four types of metrics:

Data Point – A real number from your data. Like "total spending on groceries" pulls your actual grocery expenses.

Constant – A fixed number that doesn't change. Like "0.05" for a 5% interest rate or tax rate. Useful for calculations that use the same percentage every time.

Variable – A number that changes based on context. Like "number of months" changes depending on your time range. Great for calculating averages (total spending ÷ number of months = monthly average).

Formula – A custom calculation you create. Combine data points, constants, and variables with math to get exactly what you need.

The formula editor

This is where you build custom calculations.

Here's what you're working with:

Formula Name – What you want to call it (click to edit)

Formula Expression – The actual math. Write it like a normal equation using references to other metrics.

Example: A × B - C

• A = Total credit card balance

• B = Interest rate

• C = Minimum payment amount

Result = Your actual interest cost

Formula Type – How the result displays:

• Number – Regular number (like 42)

• Percentage – Shows as a percent (like 15%)

• Money – Shows as currency (like $1,234.56)

Formula References – The metrics you're using in your calculation (like A, B, C above). Each reference can be any type of metric.

Variable visibility (the cool interactive part)

See the eye icon next to each reference? That controls visibility.

When visible: People viewing your page can see that metric AND change it to see how the formula result changes.

Why this matters: You can build calculators and share them. Like a "how much will I pay in interest?" calculator where people can plug in their own numbers.

It's a great way to let others explore the data and play with different scenarios without actually changing your real data.

Real use cases:

• Calculate your debt payoff timeline

• Project future savings based on different monthly contributions

• See how much interest you'll pay on different credit card balances

• Calculate investment returns with different rates

• Build "what if" scenarios for any financial decision

Basically, if you can think of a calculation, you can build it.

Want to see it in action? Import the "Formula Demo" template from the gallery and play around with it.

Formulas = endless possibilities. Get creative. 🚀