Newb calculation help

Follow

Rick Nash

• May 10, 2023 06:48

Hi there!

I am working on a mileage reimbursement form. I am trying to use an IF statement in a calculation field. I want the calculation to be IF the type of transportation is gas, then do a calculation. If it is not gas, then do a different type of calculation. This is what I have so far:

if (@Type of Transportation = "Gas") { @Miles * .52} else {@Total Cost of Item 1 + @Total Cost of Item 2 + @Total Cost of Item 3 + @Total Cost of Item 4 + @Total Cost of Item 5 + @Total Cost of Item 6}

The beginning part (before the else) works great. However, it does not perform the second calculation if the Type of transportation is not "gas". It simply returns a 0 no matter what is in the item cost fields. 

Any help or advice as a new Podio user would be appreciated. 

0

• 

  Rainer Grabowski

  • May 10, 2023 13:54

  Hi RIck,
  "equal" in a comparison needs 2 ==;

  var result = 0;
  if (@Type of Transportation == "Gas") { 
  result = @Miles * .52;
  } else {
  result = @Total Cost of Item 1 + @Total Cost of Item 2 + @Total Cost of Item 3 + @Total Cost of Item 4 + @Total Cost of Item 5 + @Total Cost of Item 6;
  }
  result    

   

   

  0

  Comment actions Permalink

Please sign in to leave a comment.