Skip to main content
August 23, 2024
Solved

Absolute values on cells in cube view

  • August 23, 2024
  • 2 replies
  • 0 views

Good day 

I was wondering via format or conditional formatting how can we get the value shown on the cell to be absolute?

Regards

Best answer by RehaanAbdulla

So i opted for using a condition which is 

If CellAmount < 0 Then FliSign = True 

and this worked

2 replies

August 23, 2024

You could use a format like this:

NumberFormat = [#,###,0;#,###,0;0]

RehaanAbdullaAuthorAnswer
August 26, 2024

So i opted for using a condition which is 

If CellAmount < 0 Then FliSign = True 

and this worked