Forum Discussion
KingslySamuel1
8 years agoQrew Assistant Captain
Thanks Aiden. It is working on cases where there is a value on all 3 fields. If one of them is yet to come to pass (e.g., two stages are crossed with a delay and the third stage is yet to start), the 4th field (with the above formula) is not showing any result. Can it be fixed, even if the one of the 3 stages has "null/no/0" for a value? Sometimes, we do have cases where we skip a stage and move the project right into the next one, where, only 2 stages have applicable delays and the third one might not. Thanks for your help.
AmmarAl-Hadeeth
8 years agoQrew Member
Please try below and let me know:
totext(
if ( [Formula 1] = null or [Formula 1] = "" , 0 , toNumber([Formula 1] )+if ( [Formula 2] = null or [Formula 2] = "" , 0 , toNumber([Formula 2] )+if ( [Formula 3] = null or [Formula 3] = "" , 0 , toNumber([Formula 3] )
)
totext(
if ( [Formula 1] = null or [Formula 1] = "" , 0 , toNumber([Formula 1] )+if ( [Formula 2] = null or [Formula 2] = "" , 0 , toNumber([Formula 2] )+if ( [Formula 3] = null or [Formula 3] = "" , 0 , toNumber([Formula 3] )
)