expression query

[#1]

hi all,

i have 2 dimensions and 1 expression:

Date     Client     Value

T          abc          10

T-1       abc          5

T          xyz          10

while writting expression

( sum({<Date = T>}[Value]) / sum({<Date = T-1>}[Value] ) -1 as Change

i get output as

Client     Change

abc          50%

xyz          -

i want to show for xyz change as 100%

please advise

thanks

[Gysbert_Wassenaar]

Try: alt(( sum({<Date = T>}[Value]) / sum({<Date = T-1>}[Value] ) -1,1)

[#3]

thanks that is working for above scenario

now if for client xyz T value is blank and T-1 is 10

then also i want to show change as -100%

how to go about

[#4]

any updates on the above?