Adding a calcuation

 2 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
David Williams
Veteran Member
Posts: 1127
Veteran Member

    I need to take annual contributions and divide them by 24 to include in my Notification. Is there a way to do this in the InfoSet or in the Notification?

    David Williams
    Jim Kripps
    New Member
    Posts: 2
    New Member

      David,

      The only way I have found to do this is to use a CSV file containing the constants not found in the database as the source for an infoset.  Then you can use the data in the CSV for calculations.

      Chris Martin
      Veteran Member
      Posts: 277
      Veteran Member

         You should be able to do this in your sql (in the infoset).  Add a field to your query where ("contribution amt")/24.