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



      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,