Forum Discussion

magic_mic's avatar
magic_mic
Data Storage
09-11-2023

Sisense pivot table conditional font color format

Hi All,

Does anyone know of any script so that if the cell value is negative (<0), the font color in Sisense pivot table in all fields changes to red (#ff0000) but all other value formatting (such as %, decimal point and separator) in the fields remains unchanged?

-192,154,645 --> -192,154,645

-2.2% --> -2.2%

Thank you for your help in advance.

Cheers,

Mike