If - then calculation via category

Follow

Tue Roth

• February 19, 2016 08:41

Hi, 

I'm trying to make a simple calculation where IF a category field is set to "X" THEN return a specific number or text in a calculation field.

Eg. IF "employee status" = type A, THEN show "15%"

or IF "employee status" = type B, THEN show "150"

I tried various combinations of what I could find online here, but nothing that worked so far. 

Best, Tue 

0

• 

  Rainer Grabowski

  • February 19, 2016 20:02

  Hi Tue,

  @employee status == "type A" ? "15%" : @employee status == "type B" ? "150" : 0

  Rainer

  2

  Comment actions Permalink
• 

  Tue Roth

  • February 23, 2016 15:45

  Hi Rainer, 

  Thanks a lot - it worked like a charm :)

  0

  Comment actions Permalink
• 

  Reece Carter

  • April 18, 2016 21:03

  @RAINER similar to this calc, how can get a result for BOTH categories to give a result?

   

  Eg. IF "employee status" = type A & type B, THEN show "165%"

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • April 18, 2016 21:39

  Hi Reece,

  is @employe status a multi choice category field or a single choice? If single choice it's if Type A OR Type B. If multiple choice both (OR and AND) are possible

  For single choice: 

  var es = @employe status;
  es == "TypeA" || es = "Type B" ? "165%" : ""

  
  For multiple choice AND (= both have to be selected): 

  var es = @employe status.join();
  es.indexOf("TypeA") > -1  &&  es.indexOf("TypeB") > -1 ? "165%" : ""

  For multiple choice OR (= either Type A or Type B have to be selected): 

  var es = @employe status.join();
  es.indexOf("TypeA") > -1  ||  es.indexOf("TypeB") > -1 ? "165%" : ""

  But be aware that "165%" is a text string, which is hard to use for further calculations (e.g. for sums).

  Rainer

  0

  Comment actions Permalink
• 

  Dan Stroehlein

  • August 27, 2016 11:40

  How do you use this but return a text string that is a reference from the app?

   

  0

  Comment actions Permalink
• 

  Rainer Grabowski

  • August 27, 2016 13:20

  Hi Dan, sorry, I don't understand what you mean. What exactly do you want to do? Getting a string from a text field in a related app?

  Rainer

  0

  Comment actions Permalink
• 

  Dan Stroehlein

  • August 27, 2016 13:27

  Hi Rainer,

   

  I actually figured it out instead of putting "100%" I wanted to display a specific app reference so I did (@Schedule) and it worked!  This thread helped a lot, thanks!

  0

  Comment actions Permalink
• 

  Ashley

  • March 08, 2017 07:22
  • Edited

  I have a similar question. How would the calculation go for:

   

  IF "employee status" = type A or type B, THEN show "Red"

  or IF "employee status" = type C or type D, THEN show "Blue"

   

  EDIT:

  I got it.

  Using a nested calculation with brackets.

  @employee status == "type A" || @employee status == "type B" ? "Red" : (@employee status == "type C" || @employee status == "type D" ? "Blue" : 0)

  0

  Comment actions Permalink

Please sign in to leave a comment.