I have only the personal edition so I can not post an example of my QV doc, I will try my bestest to describe my issue as clear as possible.
I have a QV doc loaded from numerous Excel files!
One of these files is called Accounts; there are 2 particular fields in this report that I am concerned with, [Number of Structured] and [Number of Unstructured].
Now I have a second excel sheet called Customers, one of the fields is called [type of Query],
What I wish is that ,in the script I sum the 2 fields from accounts and load it as a result ( Auto Confos!!) in Customers, this is what I have tried and although it does change my results , it does not change it correctly.
Please ignor the From part of the load I took it out because it was like 5 lines long
Hope someone can help
([Number of Structured]+ [Number of Unstructured])='Auto Confos'as[Type of Query],
What I wish is that ,in the script I sum the 2 fields from accounts and load it as a result ( Auto Confos!!) in Customers,
What is this means,? You are storingas Auto Confos in customer table?
Sorry, didnot get your problem. Could you please post a sample application and explain your requirement (people who has license key would be able to open any application, so pl dont mind to post your sample application)
In the our Job , everytime a structured or unstructured event happens we also have to complete a "Auto Confo", as our excel files are manually updated I wish that every time we log a Structured or unstructured QV knows that we wuld have to do a Auto Confo, so our guys would not have to log an Auto Confo on customer.
The account spreadsheet has a 2 columns Called Structured and another called Unstructured.
These have numeric values , this is loaded into QV as activity Rollover.
I have a second spreadsheet and its activity is customer. One of the columns on this is Type of Query. So I wish that the sum of Struct and Unstruct is added to the number column in Customer and the column Type of query recognises it as Auto Confo.
The above are the 2 spread sheets fso for example on the 7 March I would like QV to count 87 Types of query as Auto Confo,
( 87 being the sum of 38 and 49 Struct and Unstruct)