Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I have a problem using a variable in an expression.
I have the variable "v_date" = insert by user (for example = today() )
Then other two variables "v_Range_Offer" = (v_date - DataOffer) and "v_Range_Confirm" = (v_date - DataConfirm) .
I must do the profiling of clients, like this in the other variable "v_Profiling":
if(
( isnull( aggr(count( {$< v_Range_Offer={">0 <=1825"} >} [Offerta Seriale]) , [Cliente.Seriale] ) ) ) and
( isnull( aggr(count( {$< v_Range_Confirm={">0 <=1825"} >} [Pratica Seriale]) , [Cliente.Seriale] ) ) ), 'A.Suspect',
if(
( aggr(count( {$< v_Range_Offer={">0 <=730"} >} [Offerta Seriale]) , [Cliente.Seriale] )>=1 ) and
( isnull( aggr(count( {$< v_Range_Confirm={">0 <=730"} , [Tipo]={"P", "PO"} >} [Pratica Seriale]) , [Cliente.Seriale] )) ),
'B.Prospect', 'Z.Other'))
This don't work, neither with the expansion $ in the variable.
Any suggestion?
Thank you, Gabriele.