We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

how do i display negative numbers like in excel

Answered
niraj asked on April 13, 2018

for example I might want a negative number with parenthesis (212,33.12)
or I might want it with a negative sign -212,313.12
or I might want it in red etc 
i'm interested in the common excel variations

1 answer

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 16, 2018

Hello Niraj,
Thank you for your question. We recommend trying our customizeCell feature - https://www.flexmonster.com/api/customizecell/. It is a really powerful tool for changing pivot's view. Here is an example of how it can be used - http://jsfiddle.net/flexmonster/cc2kyzfe/.
Please let us know if it works for you.
Regards,
Dmytro

Please login or Register to Submit Answer