You can use a function in an expression to perform actions on data in data regions, groups, and datasets. You can access these functions under the Common Functions node within the Expression Editor dialog. In any property that accepts expressions, you can drop down the property and select \ to open the dialog.
Refer to the following tables that contain details about each of the functions included in Wyn Enterprise for use in property expressions.
DateAdd(DateInterval,Number,DateTime)
{DateAdd("d", 5, SaleDate)}; {DateAdd(DateInterval.Day, 5, SaleDate)}
DateDiff(<DateInterval>, <DateTime1>, <DateTime2>[, <DayOfWeek>[, <WeekOfYear>]])
{DateDiff("yyyy", SaleDate, "1/1/2015")}; {DateDiff(DateInterval.Year, SaleDate, "1/1/2015")}
DatePart(<DateInterval>, <DateTime>[, <FirstDayOfWeek>[, <FirstWeekOfYear>]])
{DatePart("m", SaleDate)}
DateSerial(<Year Number>, <Month Number>, <Day Number>)
{DateSerial(DatePart("yyyy", SaleDate) - 10, DatePart("m", SaleDate) + 5, DatePart("d", SaleDate) - 1)}
DateString()
{DateString()}; {DatePart("m", DateString())}
DateValue(<StringDate>)
{DateValue("December 12, 2015")}
Day(<DateTime>)
{Day(SaleDate)}
Hour(<DateTime>)
{Hour(SaleDate)}
Minute(<DateTime>)
{Minute(SaleDate)}
Month(<DateTime>)
{Month(SaleDate)}
MonthName(<Month Number>[, <Abbreviate>])
{MonthName(MonthNumber)}
Now()
{Now()}
Second(<DateTime>)
{Second(SaleDate)}
TimeOfDay()
{TimeOfDay()}
Timer()
{Timer()}
TimeSerial(<Hour Number>, <Minute Number>, <Second Number>)
{TimeSerial(DatePart("h", SaleDate), DatePart("n", SaleDate), DatePart("s", SaleDate))}
TimeString()
{TimeString()}
TimeValue(<StringTime>)
{TimeValue("15:25:45")}; {TimeValue(SaleDate)}
Today()
{Today()}
Weekday(<DateTime>[,<DayOfWeek>])
{Weekday(SaleDate, 0)}
WeekdayName(<WeekDay>[, <Abbreviate>[, <FirstDayOfWeek>]])
{WeekdayName(3, true, 0)}; {WeekDayName(DatePart("w", SaleDate), true, 0)}
Quarter(<DateTime>)
{Quarter(SaleDate)}
QuarterName(<DateTime>)
{QuarterName(SaleDate)}
Year(<DateTime>)
{Year(SaleDate)}
<DateTime>.AddYears(<Number>)
{OrderDate.AddYears(3)}
<DateTime>.AddMonths(<Number>)
{OrderDate.AddMonths(2)}
<DateTime>.AddDays(<Number>)
{OrderDate.AddDays(5)}
<DateTime>.AddHours(<Number>)
{OrderDate.AddHours(12)}
<DateTime>.AddMinutes(<Number>)
{OrderDate.AddMinutes(30)}
<DateTime>.AddSeconds(<Number>)
{OrderDate.AddSeconds(30)}
<DateTime>.AddMilliseconds(<Number>)
{OrderDate.AddMilliseconds(500)}
DateTime.Parse(<String>[, <String>])
{DateTime.Parse("01/01/1970")}
Abs(<Number>)
{Abs(-5.5)}; {Abs(YearlyIncome - 80000)}
Acos(<Number>)
{Acos(0.5)}; {Acos(Angle)}
Asin(<Number>)
{Asin(0.5)}; {Asin(Angle)}
Atan(<Number>)
{Atan(0.5)}; {Atan(Angle)}
Atan2(<Number1>, <Number2>)
{Atan2(3, 7)}; {Atan2(CoordinateY, CoordinateX)}
BigMul(<Number1>, <Number2>)
{BigMul(4294967295, -2147483647)}; {BigMul(Int32Value, Int32Value)}
Ceiling(<Number>)
{Ceiling(98.4331)}; {Ceiling(AnnualSales / 6)}
Cos(<Number>)
{Cos(60)}
Cosh(<Number>)
{Cosh(60)}
E
{E * 2}
Exp(<Number>)
{Exp(3)}; {Exp(IntegerCounter)}
Fix(<Number>)
{Fix(-7.15)}; {Fix(AnnualSales / -5)}
Floor(<Number>)
{Floor(4.67)}; {Floor(AnnualSales / 12)}
IEEERemainder(<Number1>, <Number2>)
{IEEERemainder(9, 8)}
Log(<Number>)
{Log(20.5)}; {Log(NumberValue)}
Log10(<Number>)
{Log10(20.5)}; {Log10(NumberValue)}
Max(<Values>)
{Max(OrderTotal)}
Min(<Values>)
{Min(OrderTotal)}
PI
{2 * PI * Radius}
Pow(<Number1>, <Number2>)
{Pow(Quantity, 2)}
Round(<Number>)
{Round(12.456)}; {Round(AnnualSales / 12.3)}
Sign(<Number>)
{Sign(AnnualSales - 60000)}
Sin(<Number>)
{Sin(60)}
Sinh(<Number>)
{Sinh(60)}
Sqrt(<Number>)
{Sqrt(121)}
Tan(<Number>)
{Tan(60)}
Tanh(<Number>)
{Tanh(60)}
Truncate(<Number>)
{Truncate(UnitPrice)}
<String>.Contains(<String>)
{ShipAddress.Contains("street")}
<String>.EndsWith(<String>)
{Description.EndsWith("documents")}
<String>.IndexOf(<String>[, <Number>])
{Description.IndexOf("documents")}
InStr(<String>, <String>)
{InStr(Description, "documents")}
<String>.LastIndexOf(<String>[, <Number>])
{Description.LastIndexOf("documents")}
<String>.Replace(<String>, <String>)
{Description.Replace("documents", "invoices")}
<String>.StartsWith(<String>)
{Description.StartsWith("Invoice")}
<String>.Substring(<Number>, <Number>)
{Description.Substring(1, 10)}
<String>.ToLower()
{ShipCountry.ToLower()}
<String>.ToUpper()
{ShipCountry.ToUpper()}
<String>.Trim()
<String>.TrimEnd()
<String>.TrimStart()
IsArray(<Expression>)
{IsArray(@Initials)}
IsDate(<Expression>)
{IsDate(BirthDate)}; {IsDate("31/12/2010")}
IsDBNull(<Expression>)
{IsDBNull(MonthlySales)}
IsError(<Expression>)
{IsError(AnnualSales = 80000)}
IsNothing(<Expression>)
{IsNothing(MiddleInitial)}
IsNumeric(<Expression>)
{IsNumeric(AnnualSales)}
DBNull.Value
{IIF(Organization is DBNull.Value, "<NULL>", Organization)}
Choose(<Index>, <Value1>[, <Value2>,...[, <ValueN>]])
{Choose(3, "10", "15", "20", "25")}
IIF(<Condition>, <TruePart>, <FalsePart>)
{IIF(AnnualSales >= 80000, "Above Average", "Below Average")}
Partition(<Value>, <Start>, <End>, <Interval>)
{Partition(1999, 1980, 2000, 10)}
Switch(<Condition1>, <Value1>[, <Condition2>, <Value2>,...[, <ConditionN>, <ValueN>]])
{Switch(FirstName = "Abraham", "Adria", FirstName = "Charelotte", "Cherrie")}
AggregateIf(<Condition>, <AggregateFunction>, <AggregateArguments>)
{AggregateIf(Discontinued = true, "Sum", InStock)}
AggregateIf(<Condition>, <AggregateFunction>, <AggregateArguments>, <Scope>)
{AggregateIf(Discontinued = true, "Sum", InStock, "Category")}
Avg(<Values>)
{Avg(LifeExpentancy)}
Avg(<Values>, <Scope>)
{Avg(LifeExpentancy, "GroupByCountry")}
Count(<Values>)
{Count(EmployeeID)}
Count(<Values>, <Scope>)
{Count(EmployeeID, "Title")}
CountDistinct(<Values>)
{CountDistinct(OrderID)}
CountDistinct(<Values>, <Scope>)
{CountDistinct(OrderID, "GroupByCategory")}
CountRows()
{CountRows()}
CountRows(<Scope>)
{CountRows("Title")}
CrossAggregate(<Expression>, <FunctionName>, <ColumnGroupName>, <RowGroupName>)
{CrossAggregate(Amount, "Sum", "YearGroup", "CategoryGroup")}
CumulativeTotal(<Expression>, <Aggregate>)
{CumulativeTotal(OrderID, "Count")}
DistinctSum(<Values>, <Value>)
{DistinctSum(OrderID, OrderFreight)}
DistinctSum(<Values>, <Value>, <Scope>)
{DistinctSum(OrderID, OrderFreight, "Order")}
First(<Values>)
{First(ProductNumber)}
First(<Values>, <Scope>)
{First(ProductNumber, "Category")}
Last(<Values>)
{Last(ProductNumber)}
Last(<Values>, <Scope>)
{Last(ProductNumber, "Category")}
Max(<Values>, <Scope>)
{Max(OrderTotal, "Year")}
Median(<Values>)
{Median(OrderTotal)}
Median(<Values>, <Scope>)
{Median(OrderTotal, "Year")}
Min(<Values>, <Scope>)
{Min(OrderTotal, "Year")}
Mode(<Values>)
{Mode(OrderTotal)}
Mode(<Values>, <Scope>)
{Mode(OrderTotal, "Year")}
RunningValue(<Values>, <AggregateFunction>)
{RunningValue(Price, "Sum")}
RunningValue(<Values>, <AggregateFunction>, <Scope>)
{RunningValue(Price, "Sum", "Nwind")}
StDev(<Values>)
{StDev(LineTotal)}
StDev(<Values>, <Scope>)
{StDev(LineTotal, "Nwind")}
StDevP(<Values>)
{StDevP(LineTotal)}
StDevP(<Values>, <Scope>)
{StDevP(LineTotal, "Order")}
Sum(<Values>)
{Sum(Price)}
Sum(<Values>, <Scope>)
{Sum(Price, "Category")}
Var(<Values>)
{Var(LineTotal)}
Var(<Values>, <Scope>)
{Var(LineTotal, "Order")}
VarP(<Values>)
{VarP(LineTotal)}
VarP(<Values>, <Scope>)
{VarP(LineTotal, "Order")}
ToBoolean(<Value>)
{ToBoolean(HouseOwnerFlag)}
ToByte(<Value>)
{ToByte(ProductNumber)}
ToChar(<Value>)
{ToChar(OrderStatus)}; {ToChar("Hello")}
ToDateTime(<Value>)
{ToDateTime(SaleDate)}; {ToDateTime("1 January, 2017")}
ToDecimal(<Value>)
{ToDecimal(Sales)}
ToDouble (<Value>)
{ToDouble(AnnualSales)}; {ToDouble(535.85 * 0.2691 * 67483)}
ToInt16(<Value>)
{ToInt16(AnnualSales)}; {ToInt16(535.85)}
ToInt32(<Value>)
{ToInt32(AnnualSales)}
ToInt64(<Value>)
{ToInt64(AnnualSales)}
ToSingle(<Value>)
{ToSingle(AnnualSales)}; {ToSingle(15.857692134)}
ToString(<Value>)
{ToString(YearlyIncome)}; {ToString(13.5)}
.ToString(<Value>)
{OrderDate.ToString("dd MMM yyyy")}
ToUInt16(<Value>)
{ToUInt16(AnnualSales)}
ToUInt32(<Value>)
{ToUInt32(AnnualSales)}
ToUInt64(<Value>)
{ToUInt64(AnnualSales)}
Format(<Value>)
{Format(OrderDate, "dd MMM yyyy")}
NumberToWords(<Value>)
{UserContext.NumberToWords(123.5)}; {UserContext.NumberToWords(981, "zh-CN")}
GetFields()
{GetFields()}; {Code.DisplayAccountID(GetFields())}
InScope(<Scope>)
{InScope("Order")}
Level()
{Level()}
Level(<Scope>)
{Level("Order")}
Lookup(<Source>, <Destination>, <Result>, <DataSet>)
{Lookup(ProductID, ProductID, Quantity, "DataSet2")}
LookupSet(<Source>, <Destination>, <Result>, <DataSet>)
{LookupSet(ProductID, ProductID, Quantity, "DataSet2")}
Previous(<Expression>)
{Previous(OrderID)}
Previous(<Expression>, <Scope>)
{Previous(OrderID, "Order")}
RowNumber()
{RowNumber()}
RowNumber(<Scope>)
{RowNumber("OrderID")}
<Collection>.GetLength(<Number>)
<Object/Record>.Item(<String>)
{Fields.Item("Company Name").Name};
{Parameters.Item("Parameter1").Name}
{ReportItems.Item("TextBox1").Value}
Join(<Values>, <String>)
{Join(@MultiValueParameter, ", ")}
UserContext.getValue(<String>)
{UserContext.getValue("name")}
UserContext.T(<String>)
{UserContext.T("translationKey")}