...
Tip |
---|
n%2 !=0 shows if the number is divided by 2 does have a remainder than the number is "Odd" |
Code Block |
---|
n=[Average: WB1]; if( n%2==0, "Even", if (n% 2 != 0, "Odd", "Unknown" ) ) |
...
Code Block |
---|
case([Year],
1960, "R",
1961, "D",
1962, "D",
1963, "D",
1964, "D",
1965, "D",
1966, "D",
1967, "D",
1968, "D",
1969, "R",
1970, "R",
1971, "R",
1972, "R",
1973, "R",
1974, "R",
1975, "R",
1976, "R",
1977, "D",
1978, "D",
1979, "D",
1980, "D",
1981, "R",
1982, "R",
1983, "R",
1984, "R",
1985, "R",
1986, "R",
1987, "R",
1988, "R",
1989, "R",
1990, "R",
1991, "R",
1992, "R",
1993, "D",
1994, "D",
1995, "D",
1996, "D",
1997, "D",
1998, "D",
1999, "D",
2000, "D",
2001, "R",
2002, "R",
2003, "R",
2004, "R",
2005, "R",
2006, "R",
2007, "R",
2008, "R",
2009, "D",
2010, "D",
2011, "D",
2012, "D",
2013, "D",
2014, "D",
"Unknown: " + [Year]
) |
Code Block |
---|
case([Year],
1960, "Dwight D Eisenhower",
1961, "John F Kennedy",
1962, "John F Kennedy",
1963, "John F Kennedy",
1964, "Lyndon B Johnson",
1965, "Lyndon B Johnson",
1966, "Lyndon B Johnson",
1967, "Lyndon B Johnson",
1968, "Lyndon B Johnson",
1969, "Richard Nixon",
1970, "Richard Nixon",
1971, "Richard Nixon",
1972, "Richard Nixon",
1973, "Richard Nixon",
1974, "Gerald Ford",
1975, "Gerald Ford",
1976, "Gerald Ford",
1977, "Jimmy Carter",
1978, "Jimmy Carter",
1979, "Jimmy Carter",
1980, "Jimmy Carter",
1981, "Ronald Reagan",
1982, "Ronald Reagan",
1983, "Ronald Reagan",
1984, "Ronald Reagan",
1985, "Ronald Reagan",
1986, "Ronald Reagan",
1987, "Ronald Reagan",
1988, "Ronald Reagan",
1989, "George H Bush",
1990, "George H Bush",
1991, "George H Bush",
1992, "George H Bush",
1993, "Bill Clinton",
1994, "Bill Clinton",
1995, "Bill Clinton",
1996, "Bill Clinton",
1997, "Bill Clinton",
1998, "Bill Clinton",
1999, "Bill Clinton",
2000, "Bill Clinton",
2001, "George W Bush",
2002, "George W Bush",
2003, "George W Bush",
2004, "George W Bush",
2005, "George W Bush",
2006, "George W Bush",
2007, "George W Bush",
2008, "George W Bush",
2009, "Barack Obama",
2010, "Barack Obama",
2011, "Barack Obama",
2012, "Barack Obama",
2013, "Barack Obama",
2014, "Barack Obama",
"Unknown: " + [Year]
) |