Skip to main content
Rahul G 提问于 #Formulas

I have two custom fields - Temperature__c  and Relative_Humidity__c  for get value from user .

then I create one formula field to calculate  Dew Point (DPF) -->DPF__c (Formula (Number))

-(DPC__c * 1.8) + 32.

 

we want below scenarios answers 

Scenario -1

if user Enter  Temperature__c   -  52 and Relative_Humidity__c  - 5

then we want--> Dew Point: -17.44°F

Scenario - 2

if user Enter  Temperature__c   -  25  and Relative_Humidity__c  - 20

then we want -->Dew Point: -10.86°F

but when trying to implement that time it does not work as I accept.

kindly refer attachment FYI...

 

thank You...

I have a Formula Field for calculating the Dew Point (DPF) but it was not work properly

 

Screenshot 2023-04-10 155708 -- 2.png

 

Screenshot 2023-04-10 160513 - 3.png

 

Screenshot 2023-04-10 160847 -- 4.png

2 个回答
  1. 2023年4月11日 05:53

    @Madhumitha Narasimhan

    A= 17.27; B= 237.7; TF = Temp Fahrenheit; TC = Temp Celsius; DPC = Dewpoint Celsius, DPF = Dewpoint Fahrenheit

    RH = Relative Humidity %

     RH  - User Enter

     TF   -  User Enter 

     

    TC = (TF - 32) * (5/9)         // convert to Celsius

    X = ((A * TC) / (B + TC)) + ln (RH/100.0)

    DPC = (B * X) / (A - X)

    DPF = (DPC * 1.8) + 32     // convert to Fahrenheit

0/9000