EvGET

The EvGet (Get) function retrieves a data value based on one or more specified members. Report templates use the EvGTS function instead of the EvGET function, since the EvGTS function gets a value, and also allows you to scale the returned value.

Syntax Syntax

EvGET(AppName,[dim:]member1,[dim:]member2,...[dim:]memberN)

AppName — The name of the application. This is required if the corresponding dimension does not exist in the active application.

Member1–n — You can specify as many members that you want. Any dimension not specified in the formula is taken from the current view. If you only supply the period and not the year, EvGET uses the year from the Category's YEAR property. For example, EvGET(Finance, Jan,Budget,GlobalMotors,Revenue,AllProducts) uses the year specified in the Budget category YEAR property. If that year is 2008, the example gets data for the period Jan.2008.

If the same member name is used in more than one dimension, you must specify the dimension name. Use this syntax: dimension:member.

End of the code.

Example Example

The following example returns $500,000.00 from the database. EvGET(Finance,Account.Sales,Entity.Sales,Jan.2008,Budget)

End of the example.