calc with GetSummary function displaying zero or null

Discussion created by disabled_christipalme on Aug 24, 2012
Latest reply on Aug 24, 2012 by steve_ssh

Have an odd situation, I'm hoping someone has run into and solved already.


I have a solution where in one table, a calculation that uses subsummary data to determine the percent of the whole for the subsummary section works fine and another table in the same solution using the type calculation always shows either zeros or nothing. When looking at the calculation with the dataview, the calculation resolves perfectly but it won't display on the layout.


the calculation is:


GetSummary ( countsummaryfield ; breakfield ) / countsummaryfield )


the records are sorted by the breakfield and the calculation engine appears to get it since the data view can show me the result.


Any ideas?


oh, this is in Filemaker 11