• p_harrold
  • NEWBIE
  • 0 Points
  • Member since 2012

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 2
    Questions
  • 3
    Replies

Within an if statement I want to print a line break to the screen. However, there seems to be no easy way to do this in any forums thus far. I found a few answers, but none of them seem to work within the TRUE argument in my IF conditional statement. Here is a snippet of my code:
{! IF (relatedTo.Budget_In_Stream_Video__c != null, "In-Stream Video", null)}
{! IF (relatedTo.Budget_Interactive_InStream_Video__c != null, "Interactive In-Stream Video", null)}

Outputs

I have tried \n, <br/>, and many others with little or no success. BR() only gives this output:
In-Stream Video_BR_ENCODED_Interactive In-Stream Video

 

Someone please tell me I'm crazy and this isn't that hard and doesn't require some crazy hack...

I'm having trouble with the compiled size of a formula. I don't understand why this is compiling into so many characters. The formula simply adds 14 fields together, all of which are numbers. The custom number fields all have 18 digits, which I tried decreasing to 17 but it did not change the compile size. I've also tried changing the field label and field name of each of these 14 fields. I currently have it so it only adds up 13 of the 14 fields (which needs to change) because it can save that way.

 

Also, strangely enough, when I click "Check Syntax" it gives a compiled size of 529 characters.

 

Here is the full error when I try to save the formula:

Error: Invalid Data.
Review all error messages below to correct your data.
Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (5,011 characters). Maximum size is 5,000 characters

 

Here is my formula:

Added_Value_Interactive_InStream_Video__c
+ Added_Value_App_Banner__c
+ Added_Value_FPA__c
+ Added_Value_In_Banner_Video__c
+ Added_Value_In_Stream_Video__c
+ Added_Value_Interactive_Pre_roll_SC__c
+ Added_Value_Mobile_Web_Banner__c
+ Added_Value_Tablet_Full_Page__c  
+ Added_Value_Tablet_Leaderboard__c  
+ Added_Value_Tablet_Medium_Rectangle__c  
+ Added_Value_Tablet_Square__c
+ Added_Value_Tablet_Wide_Skyscraper__c
+ Added_Value_In_Stream_Video_Blend__c
+ Added_Value_Video_Blend__c
+ Added_Value_Display_Blend__c

 

Hopefully someone has an idea of how to decrease the compile size by 11 characters...

 

UPDATE: I just tried copying and pasting this formula into a new field and it compiled and saved... I gave it the same characteristics as the previous formula (return type of number, 0 decimal places, 18 characters). Is it possible I can't save this custom field because it is being used by another custom field? If so, how will I know what other field is getting too big?

Within an if statement I want to print a line break to the screen. However, there seems to be no easy way to do this in any forums thus far. I found a few answers, but none of them seem to work within the TRUE argument in my IF conditional statement. Here is a snippet of my code:
{! IF (relatedTo.Budget_In_Stream_Video__c != null, "In-Stream Video", null)}
{! IF (relatedTo.Budget_Interactive_InStream_Video__c != null, "Interactive In-Stream Video", null)}

Outputs

I have tried \n, <br/>, and many others with little or no success. BR() only gives this output:
In-Stream Video_BR_ENCODED_Interactive In-Stream Video

 

Someone please tell me I'm crazy and this isn't that hard and doesn't require some crazy hack...