2 Replies Latest reply: Mar 13, 2013 11:19 AM by Simon Goodman RSS

    Conditional Formatting in Expression

    Simon Goodman

      I have a pivot table with one expression but I need that expression to handle multiple number formats, #,##0.0%, #,##0.00, #,##0. One text field uses #,##0.00%, 15 text fields use #,##0 and the rest #,##0.0 for which I was hoping to use the Number default to handle them.

       

      I have tried to create an if statement but can not get it to fully work. All the formatting works but the Visual Cues <0 stops working, so I tried to add if to solve it. See below;

       

      =If ([AR Field]) = 'Text%', text(num(sum([PointsData[),'#,##0.0%')),

      if ([AR Field]= 'Textwholenumber', text(num(sum([PointsData]), '#,##0;(#,##0)')),

      if ([PointsData<0, 'RGB(255,0,0)'))))