Formatting on calculated field within a pivot table

[richiebkerry]

Hello,

At present if I have a positive number in the pivot field the formatting (#,##0" kW";[<1000]0" kW") generates 67,7560 kW. However, if the number is negative I have -677560 kW.

On negative numbers I would like to return (67,7560) kW but in red writing, can this be done?

Thanks in advance

Rich

​

 

[richiebkerry]

Hello,

At present if I have a positive number in the pivot field the formatting (#,##0" kW";[<1000]0" kW") generates 67,7560 kW. However, if the number is negative I have -677560 kW.

On negative numbers I would like to return (67,7560) kW but in red writing, can this be done?

Thanks in advance

Rich

​

Sorted now, thanks for the views.

 

[RoryA]

Care to share your solution in case it benefits anyone else finding this thread?

 

[richiebkerry]

Care to share your solution in case it benefits anyone else finding this thread?

#,##0" kW";[Red](#,##0)" kW"