Forum Discussion

JaredAlcantar's avatar
JaredAlcantar
Qrew Member
5 years ago

Monthly gain calculations

Hello, I'm trying to implement a way to get the daily gain of followers in our company's social media. I already have them recorded on QB by date, referral and type of interaction, I'm just wondering is there's an easy way to take the followers that social media got this month and subtract that to the followers from the previous month.

------------------------------
Jared Alcantar
Eternal Investments

------------------------------
Relationships
  • AustinK's avatar
    AustinK
    Qrew Commander
    5 years ago
    You could create several summary fields in the relationship for this so you could know how many followers you had this month and also last month and even a total of all of them from the beginning that match whatever criteria you need. With those fields you should then be able to calculate what you want by just doing a formula of [# of Social Media Follows - Previous Month] - [# of Social Media Follows - Current Month], something like that.
    • JaredAlcantar's avatar
      JaredAlcantar
      Qrew Member
      5 years ago
      I did exactly that and worked as I wanted to, thanks a bundle.

      ------------------------------
      Jared Alcantar
      Eternal Investments
      BCN
      ------------------------------