Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I need to form the correct version of this IF statement. Or, more likely, a different statement with the same outcome!
If Status = 3 then "Won"
If Status = 4 then "Lost"
If Status = BLANK then "Open"
Below is the code I'm trying and the Blank part does not seem to recognise it should display as "Open".
Any help appreciated,
Thanks
Status = (IF(opportunities[statuscode] = 3, "Won", IF(opportunities[statuscode] = 4, "Lost", IF(opportunities[statuscode] = BLANK(), "Open"))))
Solved! Go to Solution.
You could try
Status = SWITCH ( opportunities[statuscode], 3, "Won", 4, "Lost", BLANK (), "Open", "defaut value if doesn't in any prior case" )
You could try
Status = SWITCH ( opportunities[statuscode], 3, "Won", 4, "Lost", BLANK (), "Open", "defaut value if doesn't in any prior case" )
User | Count |
---|---|
15 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
3 | |
2 | |
2 |