Skip to main content
Topics#Reports & DashboardsPregunta de Eric Dreshfield
Eric Dreshfield (Dresh For Success LLC) ha preguntado en #Reports & Dashboards
20 jun 2013, 21:41

Custom Summary Formula won't allow if-then logic

When I try to use if-then logic in a custom summary formula on a report I get a syntax error....is it not possible to do this:

 

IF(Cycle_Plan_Target_vod__c.Account_Record_Type_ID_vod__c = "012E0000000Ktus", Cycle_Plan_Target_vod__c.Actual_Calls_vod__c:SUM*4, Cycle_Plan_Target_vod__c.Actual_Calls_vod__c:SUM)

 

It appears as though the "If" portion has to refer to a summarizable field...if that is the case, I think I'll have to use a custom object and populate that based on the formula above in order to report as needed.

 

Thanks...for any assistance!
2 respuestas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    21 jun 2013, 1:54
    I think you might have to move some of the formula onto the object itself in the way of a Formula(Number) field like either :

     

    IF(Cycle_Plan_Target_vod__c.Account_Record_Type_ID_vod__c = "012E0000000Ktus", 1, NULL) 

     

    or:

     

     

    IF(Cycle_Plan_Target_vod__c.Account_Record_Type_ID_vod__c = "012E0000000Ktus", Cycle_Plan_Target_vod__c.Actual_Calls_vod__c * 4 , Cycle_Plan_Target_vod__c.Actual_Calls_vod__c) 

Escribir una respuesta...
0/9000