1 Reply Latest reply: May 15, 2014 9:53 AM by alexcn _ RSS

    Improved Linking Comparisons

    alexcn _

      I would like to see some improvements to the linking of reports/databases with external files using operators other than the standard "="

       

      Specially the ability to link a file to itself automatically (for doing running sums, previous value checks and so on) and perhaps also a LOOKUP function that you could pass source/destination fields to (even a record number) to facilitate cross file referencing.

       

      Additionally the ability to look up an aggregation within a calculated field (eg the maximum of all values, or perhaps MAX dependant on a critera) Maybe like the DMAX, DMIN, DSUM functions in Excel .... this would save the added complications of a multipass operation.

       

      Many thanks,

       

      Alex