AnsweredAssumed Answered

calculation help (simple)

Question asked by kilbot on Mar 2, 2011
Latest reply on Mar 2, 2011 by TSBear

Title

calculation help (simple)

Post

Here is the calculation I started with

If (IsEmpty ( amount_final_contract) and goal_type = "RC"
  ; 0 ; amount_final_contract * amount_fed_percentage )

But what I want to do is

If AMOUNT_FINAL_CONTRACT has a value in it AND GOAL_TYPE = "RC"

then get AMOUNT_FINAL CONTRACT * AMOUNT_FED_GOAL

if not 0

thanks

Outcomes