4 Replies Latest reply on Jan 7, 2014 2:09 AM by erolst

    I think my calculation is causing unnecessary padding???


      I am using FM 13 Adv on Mac and Windows.


      I am using a custom function called GetItemRank. It looks into a valuelist and returns the left to right numeric placement of a given string.

      I pass parameters: $$MemberType and look into: $$MemTypes



      I can see in Debug that the values are there.



      As you can see, GetItemRank returns 3 when it should be 2. I suspect this is because $$MemTypes has unnecessary 'padding'.

      I tried trim and trimstring but nothing seems to work.


      Your ideas are appreciated.

      Am I on the right track about the 'padding'???