Use if not and sum formul

algrigore
algrigore
in Integrations and extensibility

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

Tagged:

Answers

  • Misbah
    Misbah

    @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

  • algrigore
    algrigore

    Data 2 should be boolean format or text?

  • Misbah
    Misbah

    @algrigore 

     

    SUM works on Number format only!

Categories