anowlan
Data Storage
Joined 3 years ago
User Profile
User Widgets
Contributions
Re: How do you create a formula that will calculate/prorate a field over a timeframe?
Hello DRay I have not received any feedback on this request. I have updated the data model to breakdown data day by day and prorated each money field by each day. Testing this out now. Thank you for response.1.3KViews0likes1CommentHow do you create a formula that will calculate/prorate a field over a timeframe?
Looking into how to create a formula that could calculate/prorate a field over a time frame if record crosses over multiple months or even last year to this year. Example: columns in data model underlined Start Date 1/26/2024 > End Date 2/4/2024 > Total Days 10 >Total of sale $1000 > Need to formula that can show me when using Simply Ask- How many days in January? - Expected 6 How many days in February? - Expected 4 How much money was earned in January? - Prorated a $100 a day x number of days = $600 How much money was earned in February ? - Prorated a $100 a day x number of days = $4001.4KViews0likes3Comments