3 Replies Latest reply: Dec 19, 2014 2:47 PM by Rob Wunderlich RSS

    counting documents with if criteria

      Hi,

       

      i despair of this... i'm trying to count Documents with a if-condition in a Text-Field. in a table i also created i set a boolean 1, if date one is higher then date today(). (just to check if my text-field counting works)  The Dimension of this table are the document numbers.

       

      in the textfield i'm unable to run the same expression

       

      if(today()>=max([Bestellungen.Date of Shipment])+45,1,0)

       

      i need the max() statement, because every document contains a few [Date of Shipment] - Dates and i only need the highest.

       

      i hope you can understand what my problem is, thank you for your help!

       

      Best,

      Tim