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
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: ]
Data 2 should be boolean format or text?
SUM works on Number format only!