Forum Discussion

RehaanAbdulla's avatar
RehaanAbdulla
New Contributor III
4 months ago

Absolute values on cells in cube view

Good day 

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

Regards

Cube View
  • RehaanAbdulla's avatar
    RehaanAbdulla
    4 months ago

    So i opted for using a condition which is 

    If CellAmount < 0 Then FliSign = True 

    and this worked

  • KarlT's avatar
    KarlT
    Contributor III
    4 months ago

    You could use a format like this:

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

  • RehaanAbdulla's avatar
    RehaanAbdulla
    New Contributor III
    4 months ago

    So i opted for using a condition which is 

    If CellAmount < 0 Then FliSign = True 

    and this worked