7 Replies Latest reply on Mar 27, 2018 11:03 AM by Deepak Rai

    Splitting 1 measure into 2 based on positive and negative numbers?

    Natalie Nocho

      Hello,

       

      Please can anyone help me out, I've really tried just about everything (I've grouped, i've binned, etc) and believe this should be a calculated field but cannot figure out the formula.

       

      I have a measure named liability. It contains both positive and negative numbers. I need to split these numbers apart and have 1 measure for anything that is 0 and above and another measure that is for everything below a 0.

       

      Can anyone assist. i don't want to reformat my source data and have two sheets separating positive / neg numbers as a work around,