Submitted by Armando on 2011/01/31 17:00
In a sample DB, let's pick the "InvoiceTotal" field which column equation is "MySum (billable). So: 1- Open the Invoice grid. 2- Put the focus on the John Doe item, "Total" Cell/field. 3- click recalculate (shift F9) 4- Total changes to 0. If you change the rate or whatever, the Invoicetotal Row equation updates the result, but the column equation doesn't. ========== I don't know how and why I didn't notice earlier. I guess I haven't worked a lot with my "finance" and projects grids lately. When today I needed to update everything project and financial... Nothing worked as expected and still doesn't. Hopefully this can fixed soon... My financial, project, and task grids depend on it.

Comments

Hi Armando,
 
I was not able to reproduce the issue, conditional hierarchy calculations work fine here.
 
Can anyone else confirm the issue ?
 
 

Yes, if someone can try the simple steps outlined above in a sample DB, it would be nice. It's absolutely not working on my side, and it's obviously working on Pierre's.

Problem is half solved : was probably due to a combination of regional settings and a dll (vb6fr.dll) I added to my system32 folder a couple weeks ago. IQ loaded that dll instead of the working one. Supressing the dll or putting it in another folder (in my case : the folder of the script needing it)fixed the problem. Pierre is working on finding out why this happened.

Pierre_Admin

2011/02/02 00:44

Permalink

OK, I was able to reproduce it. It is fixed in v0.9.25J
 
n.b. Only those with non-english VB may be affected.