Forum Discussion

RichJW's avatar
RichJW
Icon for Helper III rankHelper III
7 years ago
Solved

Adding ISBLANK into SUM Formula

Hi,   I've a SUM formula, as below, which finds the variance between two sets of numbers. Exposure Difference = SUM('Risks'[Exposure]) - SUM('Risks Prev'[Exposure])   However, the second column ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi RichJW ,

     

    Try this one.

     

    Exposure Difference =
VAR sumr =
    SUM ( 'Risks'[Exposure] )
VAR sumri =
    SUM ( 'Risks Prev'[Exposure] )
RETURN
    IF ( ISBLANK ( sumri ), 0, sumr - sumri )
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi RichJW ,

 

Try this one.

 

Exposure Difference =
VAR sumr =
    SUM ( 'Risks'[Exposure] )
VAR sumri =
    SUM ( 'Risks Prev'[Exposure] )
RETURN
    IF ( ISBLANK ( sumri ), 0, sumr - sumri )
RichJW's avatar
RichJW
Icon for Helper III rankHelper III
7 years ago

Hi v-frfei-msft,

Many thanks, this has worked beautifully.

 

Anonymous , greatly appreciate your help and efforts, however it still brought up an error when I added my table name, however it could still be my issue and not your formula.

 

It's sorted now anyway, so thank you both very much.

Rich