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]
    )
)