Use if not and sum formul




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


  • @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: ]



    Miz Logix

  • Data 2 should be boolean format or text?

  • @algrigore 


    SUM works on Number format only!