Forum Discussion

anowlan's avatar
anowlan
Data Storage
02-14-2024

How 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 unde...
dashboards & reporting
DRay's avatar
DRay
Admin
03-04-2024

Hello anowlan.

I'm sorry you haven't gotten a response to this. Please let us know if you still need a solution and we will work to find you an answer.

Thank you. 

  • anowlan's avatar
    anowlan
    Data Storage
    03-12-2024

    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. 

    • DRay's avatar
      DRay
      Admin
      03-12-2024

      Hi anowlan,

      Thank you for the update. Please keep me posted, we are happy to help if you still need it.