Forum Discussion

pardeepd84's avatar
pardeepd84
Icon for Helper III rankHelper III
5 years ago
Solved

exclude null/blanks when subtracting

Hello,   I have grouped some data together which includes the following:   Company name Client ID Double up Double up min time Double Up max time     I am now trying to subtract the ...
Need Help
Tutorial Requests
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    What if we try it like this?

    Column 1 =
ABS (
    IF (
        'Doubleup test (2)'[Double up Max Time] = ""
            || 'Doubleup test (2)'[Double up MIN Time] = "",
        BLANK (),
        'Doubleup test (2)'[Max] - 'Doubleup test (2)'[Min]
    )
)
pardeepd84's avatar
pardeepd84
Icon for Helper III rankHelper III
5 years ago

Hi jdbuchanan71 ,

 

I have tried this but it still seems to be calculating the max-min even though the double up min and double up max time columns are empty/null.  

 

 

I have grouped my data and then created 2 new columns based on actual start time (this is from the original dataset) to get the MIN and MAX values.  What I have realised is that the MIN, MAX is still being calculated even if the 'double up MIN time' and 'double up Max TIME' are blank/null.  

 

Is there a way to group data but then only calculate if the cells are blank.  My grouped data is as follows:

 

Please could I have some assistance with working this out.