Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Conditional Calculation

edited September 2003 in General
Can DBCalc be used to do only sum variables from a table on certain
conditions ??

example AMOUNT > 100 to count the number of times an amount of 100+ is
achieved ?

Comments

  • edited September 2003
    Hi Paul,

    You will need to use a TppVariable to perform a calculation like this. Try
    placing a TppVariable in the detail band with your datafield and one in the
    location you would like to see the count. Then in the first variable's
    OnCalc event, check to see if the datafield is greater than 100 and
    increment the second variable if needed.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.