Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
strange requirement
I have this a sight table in a DB where I have 2 dim and 2 expressions and 2 other dimensions as expressions
customer | account | old LOH | old L | new LOH | new L |
---|---|---|---|---|---|
COSTCO | 3245 | 0.56 | 0.11 | 0.56 | 0.11 |
AMAZON | 4546 | 0.25 | 0.26 | 0.25 | 0.26 |
WALMART | 1525 | 0.11 | 0.45 |
New LOH & new L Walmart values are blank so there I want to reflect old LOH & old L values
is it even possible ?
Thanks,
Dinesh
You may try something like -
If(isnull(Exp(newLOH)),Column(1),Exp(newLOH)
Here Column(1) denotes to old LOH exp and Column(2) denotes to old L exp.
instead of isnull you can check len() to 0 as well.
Extending to what Digvijay mentioned use Len() function like
Dims: Customer, Account
Expr1: OldLOH
Expr2: OldL
Expr3: = IF(Len(NewLoh)=0, oldLOH, NewLoh)
Expr4: = IF(Len(NewL)=0, oldL, NewL)
Alt([new LOH], [old LOH])
hope this helps
regards
Marco
if(isNull([new LOH]), [old LOH], [new LOH])