Select Page

A new knowledge base article has been published on our support portal.

Scenario Overview

In this scenario we have an Advertising company selling TV ads for a period of time with the need to calculate monthly pro-rata amounts . These TV ads were represented as Opportunities in the CRM system where you had a campaign start & end date along with an estimated revenue. 

We need to calculate on a pro-rata basis the amount of revenue for each month given the number of days in the month that the campaign would run for & store this data into 1:N related entity.

N52 Formula Manager Solution

 

View this article in full on our support portal