Forum Discussion

ADC's avatar
ADC
Frequent Visitor
9 years ago
Solved

How to show null values when I get NaN in matrix

Hello everyone   Using the Measure "Mora", I created the following Matrix.   Mora = sum(Pre_Rentabilidad[Saldo 6])/sum(Pre_Rentabilidad[Imp Cta 6])     For those cells where I get "NaN",...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago
    Mora = IFERROR(sum(Pre_Rentabilidad[Saldo 6])/sum(Pre_Rentabilidad[Imp Cta 6]);BLANK())
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago
Mora = IFERROR(sum(Pre_Rentabilidad[Saldo 6])/sum(Pre_Rentabilidad[Imp Cta 6]);BLANK())
ADC's avatar
ADC
Frequent Visitor
9 years ago

Thanks a lot!