Child pages
  • Additional Custom Expression Examples

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

 

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"
 )
)

 

 

 

 

 

Example: Presidential Party Value Change.

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]
)

 

Example: Presidential Value Change.

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]
)