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

    counting documents with if criteria



      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!