Add simple calculation to Card Summary widget | Voters

Add simple calculation to Card Summary widget

David Coenca

Being able to do simple calculations between the sum of 2 field would be very powerful.

It will avoid having to create a solution with just one record which sums all the records of another solution

January 29, 2025

WTF

Also the Display of Info side by side to reduce the height of the Cards. The Default is top / bottom & there is so much wasted space on the right. Better Visibility Controls of Labels, Display only if Value Exists, etc. Better Card Layouts in general

dougdaweb@gmail.com

being able to do basic math between one or more fields for the card summary would be a HUGE benefit. (i.e. create an easy percentage between sums etc.)

David Coenca

Hi Jon Darbyshire. 
Ideally just the division between the sum of 2 fields. 
With the "division" capability this will allow for the calculation of a weighted average.
For example with a commercial real estate portfolio, this will allow for the calculations of the (LTV) Loan to Value, Average Interest Rate, (ICO) Interest Coverage Ratio, (DSCR) Debt Service Coverage Ratio, (WAULT) Weighted Average Unexpired Lease Term.
All those ratios are a result of a weighted average based on the sum of 2 fields.
It is important to use those ratios on Dashboard views for investor's report.
We would use them on a daily basis !
Best,
David

Jon Darbyshire

Thank you for posting, David Coenca! I have a few more questions for you:

What specific types of calculations do you envision needing between the two fields?
Are there particular fields or data types that should be prioritized for this calculation feature?
How frequently do you anticipate using this calculation feature in your workflow?