Calculations Using Symbols: Category, Addition and Division - Using the ☆ Symbol

Comments

4 comments

  • Rainer Grabowski

    Hi Randall,

    you can do something like this:

     

     

     

    Note: There must be a blank space between the stars (but no blank space at the end).
    If you don't want blank spaces between the stars use: 
    split("").length instead of split(" ").length

    Rainer

    1
    Comment actions Permalink
  • Randy (BHB)

    Wow! Let me give this a shot right now! Rainer Grabowski

    0
    Comment actions Permalink
  • Randy (BHB)

    Rainer Grabowski - So it seems that would have worked but Podio did not like the fact the answer turned from "text to number". The calculation worked though. I simply can not publish the result. Please advice. Your help is greatly appreciated.

    var q1 = @Q1: My Pro Completed The Job As Described: == null ? 0 : @Q1: My Pro Completed The Job As Described:.split(" ").length;
    var q2 = @Q2: My Pro Was Punctual/On Time: == null ? 0 : @Q2: My Pro Was Punctual/On Time:.split(" ").length;
    var q3 = @Q3: My Pro's Pricing Was Affordable == null ? 0 : @Q3: My Pro's Pricing Was Affordable .split(" ").length;
    var q4 = @Q4: My Pro's Communication Was Good: == null ? 0 : @Q4: My Pro's Communication Was Good:.split(" ").length;
    var q5 = @Q5: My Pro's Quality Of Work Met and/or Exceeded My Expectations: == null ? 0 : @Q5: My Pro's Quality Of Work Met and/or Exceeded My Expectations:.split(" ").length;

    (q1 + q2)/2

     

    *** THE TYPE OF RESULT TURNED FROM TEXT TO NUMBER ***

    0
    Comment actions Permalink
  • Randy (BHB)

    Rainer Grabowski Fixed! I simply deleted the previous "calc field" and created a new "calc field" pasted the code and viola! Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk