0 Replies Latest reply on Jul 10, 2011 1:33 PM by FileKraft

    calculations based on list of values in charts inconsistent

    FileKraft

      Summary

      calculations based on list of values in charts inconsistent

      Product

      FileMaker Pro

      Version

      11v3

      Operating system version

      maCOS 10.6.8

      Description of the issue

      my formula to fetch values out of a value list in charts in the charts title calculation filed works as expected - if i use the same formula in the x-asis calculation formula it doesn't work.

      Steps to reproduce the problem

      place for example this formula into the chart title calculation:

      Let (
      [
      $index_title = $index_title + 1 ;
      $val = GetValue ( $$Type ; $index_title )
      ] ;
      $val
      )

      then create a new part underneath with the identical chart - initialize $index_title with "" via conditional formating .. - all works nicely and as expected - if you apply same logic or use $val in chart's horizontal x-axis calculation - it fails and only shows first occurrency's evaluation. (where $$type is set to list ( "a" ; "b" ; "c" ))

      Expected result

      for each chart it pulls a different value for its title and x-axis ..

      Actual result

      title work but x-axis always shows one value - doesn't use even after refresh updated values

      Workaround

      no workaround possible  - except hard wiring.

      Screen_shot_2011-07-10_at_4.28.21_PM.png