Skip to main content
Topics#Reports & DashboardsPregunta de Eric Vitucci
Eric Vitucci (EMS by DEA) preguntó en #Reports & Dashboards
3 may 2016, 16:04

Having issues with, If check box is true add numbers in a formula field

I have created a forumla field called Prep Time, I want it to add the time it takes based on if a check box is true. But I keep ending up with a total no matter if the check box is checked or not. Here is my formula.

 

IF((KIOSK__c ),0,1)+30+

 

IF((Glance__c ),0,1)+15+

 

IF((Web_App_no_PAM__c ),0,1)+45+

 

IF((Web_App_PAM__c ),0,1)+55+

 

IF((EMS_for_Outlook__c ),0,1)+20+

 

IF((Regics__c ),0,1)+90+

 

IF((Master_Calendar__c ),0,1)+90+

 

IF((Desktop_Client_Book__c ),0,1)+15+

 

IF((Desktop_Client_Dashboard__c ),0,1)+10+

 

IF((Desktop_Client_Managed_Services__c),0,1)+20+

 

IF((Desktop_Client_Reporting_BASIC__c ),0,1)+15+

 

IF((Desktop_Client_Reporting_Advanced__c ),0,1)+30+

 

IF((Desktop_Client_Configuration__c  ),0,1)+20+

 

IF((Desktop_Client_Notifications__c  ),0,1)+10+

 

IF((Desktop_Client__c ),0,1)+15
4 respuestas
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    3 may 2016, 16:08

    How about this one: 

    IF(KIOSK__c,                                30,0)+
    IF(Glance__c,                               15,0)+
    IF(Web_App_no_PAM__c,                       45,0)+
    IF(Web_App_PAM__c,                          55,0)+
    IF(EMS_for_Outlook__c,                      20,0)+
    IF(Regics__c,                               90,0)+
    IF(Master_Calendar__c,                      90,0)+
    IF(Desktop_Client_Book__c,                  15,0)+
    IF(Desktop_Client_Dashboard__c,             10,0)+
    IF(Desktop_Client_Managed_Services__c,      20,0)+
    IF(Desktop_Client_Reporting_BASIC__c,       15,0)+
    IF(Desktop_Client_Reporting_Advanced__c,    30,0)+
    IF(Desktop_Client_Configuration__c,         20,0)+
    IF(Desktop_Client_Notifications__c,         10,0)+
    IF(Desktop_Client__c,                       15,0)
Escribir una respuesta...
0/9000