Skip to main content
Topics#CollaborationErin Ryan 的问题
Erin Ryan (FactSet) 提问于 #Collaboration
2018年8月22日 20:39

Negative formula missing closing parentheses’

When the amount is negative , the field only shows one paren " ( " in the record highlight panel / compact layout.

 

  ($9,000,000     instead of >   ($9,000,000) . Character length doesn't matter.

 

IF(Total_Potential_ASV__c < 0,"(","")&" ASV: $" &

 

CASE(LEN(TEXT(ABS(Total_Potential_ASV__c))),

 

1, TEXT(ABS(Total_Potential_ASV__c)),

 

2, TEXT(ABS(Total_Potential_ASV__c)),

 

3, TEXT(ABS(Total_Potential_ASV__c)),

 

4, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 1) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),

 

5, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 2) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),

 

6, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 3) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),

 

7, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 1) & "," & MID(TEXT(ABS(Total_Potential_ASV__c)), 2,3) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),

 

8, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 2) & "," & MID(TEXT(ABS(Total_Potential_ASV__c)), 3,3) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),

 

9, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 3) & "," & MID(TEXT(ABS(Total_Potential_ASV__c)), 4,3) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),

 

10, LEFT(TEXT(ABS(Total_Potential_ASV__c)), 1) & "," & MID(TEXT(ABS(Total_Potential_ASV__c)), 2,3) & "," & MID(TEXT(ABS(Total_Potential_ASV__c)), 5,3) & "," & RIGHT(TEXT(ABS(Total_Potential_ASV__c)), 3),null)
1 个回答
  1. Keith Wiljanen (JAX Consulting)
    2018年8月23日 16:41
    Hi Erin- I see where you are creating the initial left parenthesis if the amount is less than zero, but I don't see anything that checks for creating a right parenthesis. 

     

    I think if you add:

     

    & IF(Total_Potential_ASV__c < 0, ")", "")

     

    to the end of your formula, you should be set.
撰写回答...
0/9000