Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Declaring a value in a formula field

Status
Not open for further replies.

PETEHO

Programmer
Jan 17, 2002
45
GB
If have an IF statement which generally returns a value however on occasions there will be no value to return to my formula field. How do I pre populate my formula field with the value of zero before the IF statement is run or can I put a zero in at the end. Sample code below

IF {?Period Number} = 1
Then {'B105_Nlforcm_'.base_amount01}
Else
IF {?Period Number} = 2
Then {'B105_Nlforcm_'.base_amount02}
Else
IF {?Period Number} = 3
Then {'B105_Nlforcm_'.base_amount03}
Else

Thanks

Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top