Forum Discussion

young351's avatar
young351
Frequent Visitor
4 years ago
Solved

Sum columns that contain blank values

I need to sum two columns (WHM Gas + WHM GL) that contain blanks.  I do not want to replace the blanks with zeros, but if a row contains a blank I need to treat it as zero and return the value from the other column:

 

Tips and Tricks
  • Tweeg's avatar
    Tweeg
    4 years ago

    young351  This works (not sure if it is the prettiest way to do it):

    Sum WH GAS and GL = 

    VAR

    column11 = IF(ISBLANK(Sheet1[WHM Gas]), 0, Sheet1[WHM Gas])

    VAR

    column22 = IF(ISBLANK(Sheet1[WHM GL]), 0 , Sheet1[WHM GL])

    RETURN

    column11 + column22

     

     

1 Reply

  • Tweeg's avatar
    Tweeg
    Icon for Helper I rankHelper I
    4 years ago

    young351  This works (not sure if it is the prettiest way to do it):

    Sum WH GAS and GL = 

    VAR

    column11 = IF(ISBLANK(Sheet1[WHM Gas]), 0, Sheet1[WHM Gas])

    VAR

    column22 = IF(ISBLANK(Sheet1[WHM GL]), 0 , Sheet1[WHM GL])

    RETURN

    column11 + column22