You need to sign in to do that
Don't have an account?
kumar.fdc81.3902978579608325E12
Formula field using display value
Hi
I have 3 fields
Base_Line_Hrs__c,Base_line_Billing_Rate_In_SOW_Currency__c these fields are 'Number format'.
FX_Rate_to_USD__c this field 'Formula(Number)' in this field i written formula like this
IF(
ISBLANK( FX_Rate_to_USD__c ),
Base_line_Billing_Rate_In_SOW_Currency__c * Base_Line_Hrs__c,
Base_line_Billing_Rate_In_SOW_Currency__c * Base_Line_Hrs__c * FX_Rate_to_USD__c
)
But it's not working, I need like this
if the FX rate is blank it multiplies only the Currency and Hrs..
else if FX rate is not blank, then it multiplies Currency, Hrs & FX rate ..
Thanks in adv.
I have 3 fields
Base_Line_Hrs__c,Base_line_Billing_Rate_In_SOW_Currency__c these fields are 'Number format'.
FX_Rate_to_USD__c this field 'Formula(Number)' in this field i written formula like this
IF(
ISBLANK( FX_Rate_to_USD__c ),
Base_line_Billing_Rate_In_SOW_Currency__c * Base_Line_Hrs__c,
Base_line_Billing_Rate_In_SOW_Currency__c * Base_Line_Hrs__c * FX_Rate_to_USD__c
)
But it's not working, I need like this
if the FX rate is blank it multiplies only the Currency and Hrs..
else if FX rate is not blank, then it multiplies Currency, Hrs & FX rate ..
Thanks in adv.
But result is same.
Please help me
ISBLANK( Opportunity_Margin_Template__r.FX_Rate_to_USD__c),
(Base_line_Billing_Rate_In_SOW_Currency__c * Base_Line_Hrs__c),
(Base_line_Billing_Rate_In_SOW_Currency__c * Base_Line_Hrs__c) *Opportunity_Margin_Template__r.FX_Rate_to_USD__c
)