InfoQube IM - Community

Submitted by Armando on 2010/03/05 15:09

All numbers seem to be rounded and I can't find a way to change that.

To verify what I'm talking about, add this in the row equation section of any number field (just make sure to erase it afterwards !!!) :

2*2.2

Go in your grid, click on the field and perform a re-calculation (shift-f9). You should get 4 and not 4.4.

Anybody here knows how to change that behaviour ? Pierre ?

Seems to be built in IQ, but I'm asking just in case I'm missing something.

Comments

I file that as a bug in the forum : -- link to nonexistent node ID 1507 --

calculations from previous IQ releases gave me the right real numbers... This is a very very important bug to fix... not possible to do any accounting using functions at the moment -- except for hierarchical sums. (Version 0.9.25Pre-Rel18A build 2010-02-26 22:45:32 Beta)

I just tried it and I get 4.4 ... are you sure that formatting or some other rule is not getting in the way ?

[edit] unless it is a locale issue

[quote=Pierre_Admin]

I just tried it and I get 4.4 ... are you sure that formatting or some other rule is not getting in the way ?

[edit] unless it is a locale issue

[/quote]

Thanks.

Well, I'm using the sample DB and I don't have any "user code", only "This Data base" code. So that code shouldn't interfere... or should it ?

I'll check the local issue, but column sums work. The problem seems related to multiplications and divisions maybe. I'll make a few more tests but there's definitely a problem here.

Also note that I'm using Version 0.9.25Pre-Rel18A build 2010-02-26 22:45:32 Beta, which is not the official one, but the one you sent me privately for a specific test : recalc and hierarchical equations.

If the decimal separator is a comma, 2*2.2 will give you 4. I can confirm this

It works fine when the separator is a period

[quote=Pierre_Admin]

If the decimal separator is a comma, 2*2.2 will give you 4. I can confirm this

It works fine when the separator is a period

[/quote]

Ok, so it's a "regional" setting ? Because it's not necessarily me that uses/generates commas, but IQ.

And my regional settings haven't changed and this wasn't a problem before.

[quote=Pierre_Admin]

I just tried it and I get 4.4 ... are you sure that formatting or some other rule is not getting in the way ?

[edit] unless it is a locale issue

[/quote]

Ok, seems like column equations aren't affected, only row equations. Try performing row equations with decimals.

Thanks (will be back in 40 min)

Yes, I can confirm that row equations, when using commas as decimal separator will round. A previous fix (to avoid rounding errors) worked for the usual period separator but not when using commas.

It is now fixed.

Note that equations must use the period as the decimal separator, regardless of the Windows Control Panel Regional settings. i.e. =2*2,2 does not work.

[quote=Pierre_Admin]

Yes, I can confirm that row equations, when using commas as decimal separator will round. A previous fix (to avoid rounding errors) worked for the usual period separator but not when using commas.

It is now fixed.

Note that equations must use the period as the decimal separator, regardless of the Windows Control Panel Regional settings. i.e. =2*2,2 does not work.

[/quote]

Just finished diner here... :)

Thanks for fixing that.

But, I'm not sure I understand what are the implications. I don't use comas in functions as this won't work anyway, yes.

As for IQ's grids and Gantt :

- IQ doesn't allow me to enter decimal separator other than the coma (in the grid), so I never entere anything else than comas. I guess that this depends on the regional and language settings. Mine are set to "French (Canada)" and the coma is selected.

- I don't know if you had a look at How can I use the date numbers created by the gantt chart so that my scripts don't explode..., but gantt seems to send numbers with a coma separator to my functions causing errors. Well according to my deductions. It might be something else, but I don't have the proper tools here to diagnose the problem properly. (I have other -- maybe related -- problems with the gantt, but let's start with this one .)

(Needless to say all this is quite important -- like other problems endangering data integrity.)

Will do. In the meantime, I suggest using the period as decimal separator:

Regional >> Customize >> Number

[quote=Pierre_Admin]

Will do. In the meantime, I suggest using the period as decimal separator:

Regional >> Customize >> Number

[/quote]

I think that the regional setting fixed everything. I even wonder if the row equations are now functionning properly.

What's weird though is that I haven't touched regional settings. Did something change in IQ in relation to comas/periods treatment ?

Gantt <--> grid relationship seems to work properly now (see thread on gantt and comas). Will do some further testing but will also wait for your own conclusions.

Yes... I should do tests with various decimal separators. What are common ones, other than the decimal point and the decimal comma ?

I'm no mathematician, but Wikipedia seems to indicate that the coma and the period are the most used worldwide...