Web Form Calculation Formula

By Nic | January 7, 2026

Sometimes it can be advantageous to embed a formula into a Web Form rather than include it in the database. Such circumstances may be when the use case for the formula is so specific it doesn’t warrant putting into the database, or it is a variance of two columns that are different scenarios set by…

Read More

Period End Average Selling Price

By Nic | December 4, 2025

To calculate an average price in the Year_Total/Total_Period member is quite straight forwards if you’ve got your period hierarchy as dynamic calc. It just needs a forumula. It doesn’t need to be a Two Pass calculation member. The ASP (Average Selling Price) member in my model has the following properties: The time balance and account…

Read More