calculation help (simple)
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