Adding a calcuation

 2 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
David Williams
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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.