Hi
Please see the image and cs code file.
formula for column RATE: if( [TOTAL] <>0 , [FAIL] / [TOTAL], dbnull() )formula for summary of column RATE : if( [TOTAL()] <>0 , [FAIL()] / [TOTAL()], dbnull() )summary type for column NG_KG is sum.
The first image works properly with the original value in the grid, but when the value on the cell (column NG_KG) in modified from 45 to 60, the summary value on the column RATE also changes strangely.
Is it a bug?
Thanks
Hi,
The cs code attachment, it seems that there is only one attachment for one post, :-(
By the way, this problem only happens when there are grouped columns on the groupby box, really strangely.
Hope this problem will be fixed in the near future.
Can you post a small sample project demonstrating this issue? We are not aware of any problems like this with the latest version of the controls. Your sample cs file doesn't really help, because there's too much missing, like what version you are using.
The zip file you attached here does not appear to be a valid archive file. I am unable to open it.
I attached it again, if it is not valid again, you could reply it with your mail address and I will mail it to you.
This time the file is okay. I ran your sample and the formula on the RATE column is not what you listed here. The formula for the summary in this sample is:
"if( [TOTAL()] <>0 , [NG()] / [TOTAL()] , dbnull() )"
Anyway... unless I am missing something, the NG_KG column and the summary on the NG_KG column should be having no effect at all on this formula. Is that right?
TOTAL is not 0, so the result of the summary on the RATE column should always be 2/4 = 50%. And the NG_KG column should have no effect at all.
I just want to confirm that this is the correct behavior you are expecting, because I am getting the same behavior you describe here, and it's very strange.
Thanks for your reply.
Please run the attached project, when the form shows, please do as follows:
1,make the column GRPA group by.
2,modify the value of cell on the 2nd row of column NG_KG () from 45 to 60.
3, please pay attention to the calculated summary value at the bottom of column RATE, it's wrong.
formula for column RATE : if( [TOTAL] <>0 , [NG] / [TOTAL] , dbnull() )
formula for summary at bottom of RATE : if( [TOTAL()] <>0 , [NG()] / [TOTAL()] , dbnull() )
Hi Mike,
Did you catch what the problem is? Please help to investigate it.
Hello Felix,
CAS-98958-L6M9Y4 has been created for this issue. I have logged this issue with our developers and will provide additional details via the case. I will post again here when the issue has been resolved.
OK, hope it will be fixed in the near future.
Okay, that's what I wanted to confirm.
This appears to be a bug in the controls. So I'm going to forward this thread over to Infragistics Developer Support and ask them to create a case for you and write this up as a bug for developer review.
As you can see,the formulas in the attached project source code, there is nothing connection between the column/summary NG_KG and RATE and I do NOT want such connection (also NOT my expecting), just the UltraGrid calculates the wrong smuarry value as I described in the last post.
You seem to have simply re-iterated your description of the problem here without answering my question. I understand all of that, already.
The question I am asking is...
Is there some connection in your application between the NG_KG summary and the Rate summary that I am not seeing?
It seems to me that the NG_KG summary should have NO effect on the Rate summary at all. Is that correct. I just want to confirm that that is the behavior you are expecting.