Skip to main content
Topics#Data ManagementPergunta de Dave Meixell
Dave Meixell (Partner Tech) perguntou em #Data Management
20 de abr. de 2019, 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 respostas
  1. sakshi nagpal (LTIMindtree Ltd)
    20 de abr. de 2019, 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

     

     
Escrever uma resposta...
0/9000