I am using Fixed Assets to capture information for investments. There are the same investments in multiple companies, I have a field on the FA Master Record that is common for all of these asset record and would like to create a report as follows
……………………… Units
………………………Company 1..Company 2….Amount
Investment Name…….50,000…….20,000………100,000
Where the Units are the number of units in each company and the Amount is the total dollar amount for that investment across companies (note the dots are only there to make the columns line up).
Any help would be appreciated
Thanks
Rick
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Rick,
Obviously you would use NL(Rows) to replicate the Investment Names from your master records. Then you could use NL(Columns) along with NP(Companies) to replicate your companies across columns like this:
=NL("Columns",NP("Companies"))
Then you can use an NL function (I don't know if it's NL(Sum) or NL(First) in this case) to get the amounts with a Company= filter to specify the company. Does that help?
Regards,
Hughes
Please sign in to leave a comment.