Only calculate variance IF there is a budget value?

Hello,

Var = [Amt] - [Bud]

I need to be able to modify my Var measure so that when there is NO value for budget, there is no calculation. That is to say, for Coffee below, there should be nothing in Var. Could anyone please help me?

x Q.15.zip (40.2 KB)

@michellepace
Try
Variance =
Var
VarCalc = [Amt] - [Budget]
RETURN
IF([Budget] = BLANK(),
BLANK(),
VarCalc)

Thanks.

1 Like

Perrrrfect! thank you. so simple when you know how :slight_smile: :slight_smile:

1 Like