Page 1 of 1

GM calculation

Posted: September 3rd, 2020, 3:17 am
by etuser
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

Re: GM calculation

Posted: September 3rd, 2020, 4:51 pm
by aaronw
Could you increase the length of the numeric field and rerun it?

Re: GM calculation

Posted: September 3rd, 2020, 11:50 pm
by etuser
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

Posted: September 4th, 2020, 10:41 am
by aaronw
How many decimal places are you including?

Data Viewr 7.5

Posted: October 25th, 2020, 8:37 am
by etuser
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

Re: GM calculation

Posted: October 27th, 2020, 11:58 am
by aaronw
You have two different dictionaries in the wild. For instance, one dictionary on the tablets and another in CSWeb.

Re: GM calculation

Posted: October 27th, 2020, 12:38 pm
by etuser
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.

Re: GM calculation

Posted: October 27th, 2020, 2:24 pm
by aaronw
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:
  1. Create a batch edit application to separate cases using the old dictionary and the new dictionary into two data files
  2. Use the reformat data tool to format the old data to match the new data
  3. Combine the cases together using the reformat data tool or sync it to a empty server

Re: GM calculation

Posted: October 27th, 2020, 7:18 pm
by etuser
well noted , many thanks