Absolute values on cells in cube view

RehaanAbdulla
New Contributor II

Good day 

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

Regards

1 ACCEPTED SOLUTION

RehaanAbdulla
New Contributor II

So i opted for using a condition which is 

If CellAmount < 0 Then FliSign = True 

and this worked

View solution in original post

2 REPLIES 2

KarlT
Contributor II

You could use a format like this:

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

Cheers

RehaanAbdulla
New Contributor II

So i opted for using a condition which is 

If CellAmount < 0 Then FliSign = True 

and this worked