Hi Gloria,
There are a number of different ways to do this. You cannot use one Jet Reports formulas to pull data from multiple companies; you have to use one formula per company. So you can do a number of things to get the data in one cell. If the 5 formulas are short enough, you can just add them together in the cell although this seems unlikely. You could put each formula in its own cell and hide those columns and then sum the result in another cell. If you put them in separate cells, you can use NP(Companies) to replicate your companies, either down rows or across columns and use the result in the "company=" of your formula so you only have to write the formula once. You would do something like this:
=NL("Columns",NP("Companies"))
Does this help?
Regards,
Hughes
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello,
Does anyone know what formula to use when i want to insert multiple companies into one formula. For example, i am trying to get the sales figures for all our compaines (5 in total) for one month into one cell.
Thanks,
Gloria -
Jet Reports Historic Posts Its a Pita
But NL("Sum", table, Field, Company=,1) + NL("Sum", table, Field, Company=,1) etc
should work .
To speed it up add a cell for anything in options that you use as filter ( Date range etc) on report ( NP("eval","=Options!$d$3)
Van
Please sign in to leave a comment.