Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF NOT BLANK Calculate Sum

Hello, I need your help - we have 2x columns "Outage Durations" & "C_Durations" we would like to calculate the Sum of column "C_Durations" 1st if the column/row is not Blank.   If somehow "C_Durat...
Need Help
  • FrankAT's avatar
    FrankAT
    6 years ago

    Hi Anonymous,

     Regards FrankAT

     

     

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

if i understand you correct try SUMX()

= CALCULATE(SUMX('Table', IF(ISBLANK([C_Durations]), [Outage Durations], [C_Durations]) ) )