Hello,
Do you have any idea if I could do something like this with JetReports:
=NL("SUM";"Item Ledger Entry";"=NF(;""Quantity"") * =NF(;""Qty. per Unit of Measure"")";"Item No.";"@@"&F23;"Posting Date";$AY$2;"Filters=";$G$15:$H$17)
With this I get the "Excel could not evaluate…" error when I run the report.
Within Item Ledger Entry I have various transactions for the same item but with different units of measure - this way I could get a fair sum by quantity.
Any idea is more than welcomed,
Thanks,
Elena
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Elena,
Yes you should be able to do that, but you need to get rid of the second = sign in your calculated field. Remember that a calculated field is just an Excel formula. In Excel formulas you only have a single = sign at the beginning of the formula. So you need something like this:=NL("SUM";"Item Ledger Entry";"=NF(;""Quantity"")*NF(;""Qty. per Unit of Measure"")";"Item No.";"@@"&F23;"Posting Date";$AY$2;"Filters=";$G$15:$H$17)
Does that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Thanks, Hughes!
It works great!
Elena
Please sign in to leave a comment.