If(AS_400_Ext_catch_weight__c = 0.000 (field type is Text(255)), then set value of this new field by calculating AS_400_Quantity_shipped__c (field type is Number(16,2)) * AS_400_Item_price__c (field type is Currency (16,2))
ELSE
Set the value of this field by calculating AS_400_Item_price__c (field type is Currency (16,2)) * AS_400_Ext_catch_weight__c (field type is Text(255)
For the first part , we want to check to see if AS_400_Ext_catch_weight__c is EXACTLY 0.000 as we could have a value of 10.000 in there so we do not want to use "contains."
2 respuestas
For "InvoiceItemTotal" i have taken data type as formula,decimal as 2 and below is the formula as per your requirement.
IF(AS_400_Ext_catch_weight__c = "0.000", AS_400_Quantity_shipped__c * AS_400_Item_price__c, AS_400_Item_price__c * VALUE(AS_400_Ext_catch_weight__c))
When AS 400 catch weight is 0.000
When AS 400 catch weight is 10.000
When AS 400 catch weight is 5
