Jump to content


Photo

Adding custom fields


  • Please log in to reply
1 reply to this topic

#1 wllmdodge

wllmdodge

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 29 December 2017 - 05:50 AM

I need to combine two fields together only if {c_paidmiles} is greater than 75.

What would the recommended calculation be? I can not find any thing in the documentation.

A list of attributes would be a nice feature to have.

 

What I currently have now.

={c_FuelSurchargeRate}*{c_paidmiles}



#2 wllmdodge

wllmdodge

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 01 January 2018 - 08:24 AM

A little bit of trial and error mixed in with some choice words. I came up with a workaround. "={c_Revenue}- ({c_paidmiles} > 75) *{c_FuelSurchargeRate}*{c_paidmiles}"






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users