Use if not and sum formul

Hi,

 

Can some one advise me how to use a if not construction then sum(...) else ? I would like to have some examples. .. as I tries different formulas and it seems it's not working

Answers

  • @algrigore 

     

    If there is a requirement to aggregate the selective data then use IF else statement on the DATA itself and then aggregate the new Data line

     

    Data 1 = Full Data Set

    Data 2 = IF XXX then Data 1 Else YYY

    Target Module = Data 2[SUM: ]

     

    Misbah

    Miz Logix

  • Data 2 should be boolean format or text?

  • @algrigore 

     

    SUM works on Number format only!