Forum Discussion

michaelrlas's avatar
michaelrlas
New Member
2 years ago
Solved

having a issue using operator AND with operator OR to create a calculate column

Hello i have just one database and need to create a graphic using values with accounts paid off and open accounts, but to identify then i need that on a column (open or paid of) choose open, in anoth...
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    michaelrlas I think:

    crcab = IF('ms_hippo titulos01'[titulo]="CONTAS A RECEBER"&&'ms_hippo titulos01'[abertoquitado]="A"&& ( 'ms_hippo titulos01'[codoperacao]=8||'ms_hippo titulos01'[codoperacao]=16||'ms_hippo titulos01'[codoperacao]=999 ),'ms_hippo titulos01'[Precoaj2],0)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

michaelrlas I think:

crcab = IF('ms_hippo titulos01'[titulo]="CONTAS A RECEBER"&&'ms_hippo titulos01'[abertoquitado]="A"&& ( 'ms_hippo titulos01'[codoperacao]=8||'ms_hippo titulos01'[codoperacao]=16||'ms_hippo titulos01'[codoperacao]=999 ),'ms_hippo titulos01'[Precoaj2],0)
michaelrlas's avatar
michaelrlas
New Member
2 years ago

Thanks Greg_Deckler , this correction, did the trick. 😁