GM calculation

Discussions about editing and cleaning data
Post Reply
etuser
Posts: 17
Joined: September 3rd, 2019, 5:57 am

GM calculation

Post by etuser » September 3rd, 2020, 3:17 am

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

aaronw
Posts: 329
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: GM calculation

Post by aaronw » September 3rd, 2020, 4:51 pm

Could you increase the length of the numeric field and rerun it?

etuser
Posts: 17
Joined: September 3rd, 2019, 5:57 am

Re: GM calculation

Post by etuser » September 3rd, 2020, 11:50 pm

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.

aaronw
Posts: 329
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: GM calculation

Post by aaronw » September 4th, 2020, 10:41 am

How many decimal places are you including?

Post Reply