2 Replies Latest reply on Jan 20, 2017 7:14 AM by Milton Forde

    Issue with Calc Statement

    Milton Forde
    Milton Forde Jan 19, 2017 9:40 PM

      Hello,

       

      I'm hoping someone can help me as I have reached a wall.  I have statements that will give me weight size ranges for the coffee category.  Specific ounce ranges based on the packaging for bags and cans and count ranges based on kcups.  This all resides in the data coming in.  The count size calculations works fine, but my ounce ranges are not populating and I've tried every different scenario in trying to figure out why.

       

      Attached is a sample workbook that hopefully some one will be able to pin point what I am missing.  The single serve tab is fine, calculations are working.  The bags and cans tab is where I'm having my issue.  Nothing is populating and I'm getting null.  The bags and cans size in my dimension is where my issue is with calculations.

       

      Thank you in advance.

       

      -Milton

       

      PS - i'm working off the 9.0 version because of my client.

      • 68 Views
      • Tags:
        • 1. Re: Issue with Calc Statement
          Shinichiro Murakami
          Shinichiro Murakami Ambassador Jan 19, 2017 11:41 PM (in response to Milton Forde)

          I found errors on [BAGS AND CANS SIZE] and [Size Calc]

          Primary "OUNCES" does not exist, only "OUNCE"

           

          I modified other several tiny things and don't know what is essential.

           

          You can compare "original" and "-SM"

           

           

          [BAGS AND CANS SIZE]

          wrong

          RIGHT([Base Size],6) = "OUNCES")

           

          New

          RIGHT([Base Size],5) = "OUNCE")

           

           

          one more thing, attaching packaged workbook is really helpful, but if the sample file is smaller like less than 2MB,

          it's easier to try for more people.

           

           

          Thanks,

          Shin

          2 of 2 people found this helpful
          • 2. Re: Issue with Calc Statement
            Milton Forde
            Milton Forde Jan 20, 2017 7:14 AM (in response to Shinichiro Murakami)

            Ok, thank you Shin.

             

            I will give these changes a try on my end.   Yes, sorry for the large file, I will supply a smaller one next time.

             

            Again, thank you for your help.  I really appreciate it.

             

            -Milton

            2 of 2 people found this helpful