Attempting to return the maximum value for the field Cost Amount (Actual). I can it as a field, or as a sum easily, but need to somehow return the max value for the field.
I have tried several variations of a formula below, but when run all I see is the code, no value.=NP("Formula";"Max([@[Cost Amount (Actual)]])")
Date
Votes
1 comment
-
Jet Reports Historic Posts My question is does it need to be built using the Table Builder? Getting a maximum or minimum value can be done using an NL(first) or NL(last) but I don't believe there is a way to do that in the Table Builder based on the structure of what it is building.
I don't think there is a way to do what you want using the Table Builder because you can't use NL(Last/First). I don't know your report, but you may want to think about writing the report from scratch. For example, to get the highest transaction amount for a customer in the Cust. Ledger Entry table, I would use =NL("Last","Cust. Ledger Entry","Amount ($)","+amount","*","Customer No.",$F5)
Please sign in to leave a comment.