Hello,
I have created one formula field which is like below :
Total Water F1 (PS) (Number) Treat blank fields as zeroes = true
(Preflush_Volume_F1__c * Water_Req_F1_PS__c )+( Preflush_Tonnes_F1__c * Mix_Water_F1_PS__c )
Preflush_Volume_F1 = Number field, Value = 4
Water_Req_F1_PS__c = Number field, Value = 1
Preflush_Tonnes_F1__c = Formula field:
IF( Preflush_Yield_F1__c = NULL, NULL, Preflush_Volume_F1__c/Preflush_Yield_F1__c)
Preflush_Yield_F1__c = Number Field Value = Null
Preflush_Volume_F1__c = Number Field Value = 4
Mix_Water_F1_PS__c = Number Field Value = Null
With the above given values and formula it doesn't calculate the values.
Does anyone know what is the problem here?
Try this
IF(
OR(
ISBLANK( Preflush_Yield_F1__c ),
Preflush_Yield_F1__c = 0
),
NULL,
( Preflush_Volume_F1__c / Preflush_Yield_F1__c)
)
