Filter in formula

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Filter in formula

      Hello everybody,



      is there in Palo for OpenOffice a
      posibility to geht the highest entry back?


      For example if I import an id for each
      entry to make it unique, how could I receive ONLY the max id where
      the amount isn´t zero?


      Dimensions and Elements in the
      Modeller:

      ID → 1,2,3,4,5

      Region → South; North


      Import lines:

      Id;Region;Amount

      1;South;3

      2;South;2

      3;North;5


      Max ID where amount isn´t zero / null:
      3 ← How do I get back only this information?


      Or do I have to view all entries in
      Calc (with zero supression)??



      Thx!
    • As I understand it, you have a need for subset functionality.
      Unfortunatly subsets are not yet implemented in the current version of PalOOCa, but there are plans for supporting them in future releases.

      For now I suggest to define a view in a calc sheet and use calc formulas to display the desired information on a different sheet.