Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone from the following table i want to change only specific account invest type only for account
(account no :22534435 RE INVEST into SALE) & ( account no : 35346467 TRANSFER OUT into REDEMPTION)
i.e(
ACCOUNT NO | INVEST TYPE |
20038424 | SALE |
22534435 | RE INVEST |
24355244 | RE INVEST |
46354747 | SALE |
2536436 | TRANSFER OUT |
3354343225 | REDEMPTION |
35346467 | TRANSFER OUT |
Hi
Try like below
If([ACCOUNT NO] = 22534435, 'SALE', If([ACCOUNT NO] = 35346467, 'REDEMPTION', [INVEST TYPE])) as [INVEST TYPE]
Hi
Try like below
If([ACCOUNT NO] = 22534435, 'SALE', If([ACCOUNT NO] = 35346467, 'REDEMPTION', [INVEST TYPE])) as [INVEST TYPE]