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 Mike,
Did you catch what the problem is? Please help to investigate it.
Hi,
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() )
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.
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.
The zip file you attached here does not appear to be a valid archive file. I am unable to open it.