1 Reply Latest reply on Feb 6, 2015 6:14 AM by philmodjunk

    preform find / sum field



      preform find / sum field


      In my solution i use a "conditional formatting for selected object" method to visualize the calculation below; "TABEL1::SUM_processed  ≠ 0 or TABEL2::SUM_processed  ≠ 0 or TABEL2::SUM_processed  ≠ 0"

      Now I'm looking for a calculation to visualize the record(s) the above calculation in a preform find script method.

      I do not know better than i can't searche in to a summation field, how do I solve this problem?

        • 1. Re: preform find / sum field

          your expression refers to two different tables and refers to table 2 twice for some reason. Do you want to find records from table 2 or records from table 1?

          What is the relationship linking Table1 to table2?

          One method might be to use sort records with the "re-order on summary field" option to put the groups with a zero value first or last in your report. Then there might be a way to use Omit Multiple records to omit them from a found set.