Hello all, I have a problem regarding summing of costs from a static table.
Firstly, I have table 1(trn) where it contains the id to each cost. This table is the one that gets updated whenever a consumer does a transaction with us.
Secondly, I have a Table 2(provider_rates), a static table of costs. Each time a consumer does a transaction, he/she will be charged according to the id in Table 1.
Another issue is that I am unable to use NF functions from the Table trn, as it contains too many values (60k-ish?).
I tried =NL("sum","provider_rates","cost","id","=NL(,""trn"",""id_provider_rates"")") but the sum still shows up as a single value from the static table, did I do something wrong?
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi!
I think you have things turned around. What you actually want to do is sum from the trn table and use a calculated field to get the cost from provider_rates like this:
=NL("Sum","trn","=NL(,""provider_rates"",""cost"",""id"",NF(,""id_provider_rates""))")
My one question though here is, are you using Navision? Calculated fields and filter fields only work for Navision and your table/field names don't look like Navision. If you aren't using Navision, my formula isn't going to work and you're going to have to either replicate the values or use a SQL statement to get your desired result.
Regards,
Hughes -
Jet Reports Historic Posts Thanks fhilton,
My database is under ProgreSQL, so that won't be Navision I suppose, I'll keep trying on this problem nontheless. Thanks for the input :)
Please sign in to leave a comment.