Dear Sir,
When i tried to do annual geometric mean of a monthly price survey , the cumulative Gm values exceeds the numeric value limits and end up with blank or star(*), I can see the very big numbers when i write the results to a file , Is there a way like Ln transformation to reduce the numbers and return it back after.
Many thanks
GM calculation
Re: GM calculation
Could you increase the length of the numeric field and rerun it?
Re: GM calculation
I tried the maximum numeric length 15 and it exceeds that , also tried to define a variable on the global and still that also can't hold the GM figures . finally i tried to divide the price by ten thousand , this also makes zero for items sold in cents.
Re: GM calculation
How many decimal places are you including?
Data Viewr 7.5
Dear Sir,
After collecting data in Cspro 7.5,0 (Release Date: 2020-10-08), when i tried to open the data using Data viewer of 7.5.0 ,it opens the data and stacked. I reinstall it again it the same
After collecting data in Cspro 7.5,0 (Release Date: 2020-10-08), when i tried to open the data using Data viewer of 7.5.0 ,it opens the data and stacked. I reinstall it again it the same
Re: GM calculation
You have two different dictionaries in the wild. For instance, one dictionary on the tablets and another in CSWeb.
Re: GM calculation
Dear Aaron,
Yes, you are right there was two dictionaries, but i replaced the dictionary on my Dropbox account and on the tablet with the new dictionary, this happened after data collection work started.
Yes, you are right there was two dictionaries, but i replaced the dictionary on my Dropbox account and on the tablet with the new dictionary, this happened after data collection work started.
Re: GM calculation
You say that you updated the dictionary on Dropbox and on the tablets. I'm guessing there was some fix you wanted to make mid survey? If you have to do this in the future add the new variable to the end of a record. Never change the length of a variable or add/delete a variable from the middle of a record.
Once your data is mixed up it can be a challenge to untangle it. Here are the high-level steps you'll need to take:
Once your data is mixed up it can be a challenge to untangle it. Here are the high-level steps you'll need to take:
- Create a batch edit application to separate cases using the old dictionary and the new dictionary into two data files
- Use the reformat data tool to format the old data to match the new data
- Combine the cases together using the reformat data tool or sync it to a empty server
Re: GM calculation
well noted , many thanks