Recent content by gmiller261

Probably. I can't even get that field to turn 'red' if it is negative. I am missing something basic about formulas. I've seen this in IBM examples and mine does not work. If {Customer.Last Year's Sales} > 100000 Then crGreen Else If {Customer.Last Year's Sales} < 15000 Then crRed Else...

Sorry LB, I never doubted your solution would work. I am told that crBracketedNegatives is supposed to [] the negative number. They have a formula for (123) in the Custom Style dialog box for negative numbers.

LB, I appreciate your effort. But there is a native formatting function (crBracketedNegatives). I've tried several permutations of the following to no avail. I feel the CR developer sux big time. Where have they been in the last 10 years? If {@GTAssets} < 0 Then crBracketedNegatives

Thanks that got me to the 'inner' field. But I got a dialog box that is labeled Custom Styles. There is a 'Negatives' drop down box. The dropdown box only allows - and () as formats. The only way I can see [] brackets is to click the Formula Workshop button. Then I am back to my first post...

right click gets me Format Text. I assume it is a summation. Total Assets: {@GTAssets}

Sorry do not see Format Number. See Format Text, but nothing like yours. The Formula Workshop - Editor knows about negatives with brackets. But the syntax seems cryptic to me.

Obviously I am a newbie. today. That is what I want it to do. On negative numbers bracket the asset sum, otherwise default text number Google gives me little to nothing. Thanks

Looking for a formula that give me the correct syntax to crBracketedNegatives I have this (CR XI) // This conditional formatting formula must return one of the following Negative Sign Constants: // // crNoNegativeSign // crLeadingMinus // crTrailingMinus // crBracketedNegatives // if...