thanks. i think i'm making progress here.
another question, though - our projects can fall under 3 levels - 1st, 2nd, 3rd. there is a "level" field in the projects table. I would want the third levels to sum up to the 2nd level, and the 2nd levels to sum up to the 1st level revenue, but it...
i'm embarrassed to say that i don't know whether it is vendor-supplied or was constructed internally. impromptu is the interface i'm using to run reports off of data residing in costpoint.
this project catalog gives me the following first level folders/tables:
basic project information...
i didn't "link" anything per se. i just opened up a new table, selected the "projects" catalog, and used the wizard since all of the various tables and their fields are listed to the left.
the variables were taken from different tables, from different levels.
I'm a newbie at impromptu. I'm trying to run a very basic report. I've succeeded at getting the project to show up, along with the project start/end date, project ceiling $, project type. Now I need to show how much has been billed to each project but when I insert the field for revenue since...
How can i get the median value of a column? for example i want the median of the price column for all rows. the average, count, sum, etc are easy to get. how about the median?
thanks.
I'm traditionally an Access user. I have this much bigger database to work with so am using SQL Server 7.0. The problem I've encountered is with an iif statement. In the access query I would create a field in a query by using this statement:
IIf([adqty]=0,([iaqty]),([iaqty]/[adqty])) AS...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.