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!