Skip to main content
Topics#Data ManagementDave Meixell 的问题
Dave Meixell (Partner Tech) 提问于 #Data Management
2019年4月20日 18:37

Need help with a formula.

I want to calulate the number of days outstanding from todays date to "Start Date" based on if one of the following two values (Shipped or Support Issues)  is selected from a picklist.  How would I wirte the formula?
5 个回答
  1. sakshi nagpal (LTIMindtree Ltd)
    2019年4月20日 19:43
    Hi Dave,

     

    I added "No" to your formula,

     

    IF(

     

    OR(

     

    ISPICKVAL( ForecastCategoryName , 'Certified')

     

    ,ISPICKVAL(ForecastCategoryName, 'Purchased')

     

    ,ISPICKVAL(ForecastCategoryName, 'Returned')

     

    ), "Yes","No")

     

     There are three parameters in If

     

    1)logical condition-

     

    OR(

     

    ISPICKVAL( ForecastCategoryName , 'Certified')

     

    ,ISPICKVAL(ForecastCategoryName, 'Purchased')

     

    ,ISPICKVAL(ForecastCategoryName, 'Returned')

     

    2)value if logical condition is true-"Yes"

     

    3)value if logical condition is false-"No"

     

     3rd parameter was missing in your formula

     

     
撰写回答...
0/9000