best practice to break down multiple lines of a calculation

Follow

Yohan Hidalgo

• November 19, 2015 19:44

Hi Gang!

I have this:

(@B18==="TM"?(@B13=="E"?60+8*@B17+55*(@B16-1):(@B13=="S"?1.5*(60+8*@B17+55*(@B16-1)):(@B13=="EU"?1.5*(60+8*@B17+55*(@B16-1)):(@B13=="NL"?2*(60+8*@B17+55*(@B16-1)))))):(@B13=="E"?60+8*@B17+30*(@B16-1):(@B13=="S"?1.5*(60+8*@B17+30*(@B16-1)):(@B13=="EU"?1.5*(60+8*@B17+30*(@B16-1)):(@B13=="NL"?2*(60+8*@B17+30*(@B16-1)))))))

I would like to make it work when using calculation field... but it's saying it has an unexpected )

Thanks everyone!

0

• 

  Yohan Hidalgo

  • November 20, 2015 01:13

  When checking my code editor is telling me that the error relies missing a ":" in two places,

  55*(@B16-1)))))) expected ":"
  30*(@B16-1))))))) expected ":"

  I try adding the semicolon,, but it doesn't work,,

  How can I troubleshoot this in Podio?

  0

  Comment actions Permalink
• 

  Yohan Hidalgo

  • November 20, 2015 17:28

  I fixed it by using the else if, else if, etc. I wish there was a shorter way like the top way,, just don't know that the 2 parenthesis is expecting for a ":"

  Thanks!

  0

  Comment actions Permalink

Please sign in to leave a comment.