34
2. ClickEditFormulaontheDatamenu.
TheFormulaEditorappears.
3. OpentheAllfunctionsandaggregatesfolderandscrolldowntotheRank
function.
4. Double-clickonRank.
DesktopIntelligenceaddstheRankfunctiontotheFormulawindow.
IntheFormulaEditorbox,DesktopIntelligenceaddsparenthesesand
commasautomatically,andatthebottomleft,showsthesyntaxforthe
selectedfunction.ClickFunctionHelptogetmoreinformationonthe
function.
TousetheRankfunction,youneedtoaddadimensionvariable,acomma
andthenameasurevariableinsidetheparentheses.Thefunctionthen
ranksthedimensionaccordingtothemeasure.
5. IntheVariableslist,double-clickCityandthenSalesrevenue.
DesktopIntelligencedisplaysthecompletedsyntaxintheformulas
window.
=Rank(<City>,<Salesrevenue>)
6. ClickOK.
Thecitiesarerankedfrom1to10accordingtosalesrevenue.
Tip:TofindafunctionquicklyintheFunctionslist,opentheAllfunctions&
aggregatesfolderandthentypethefirstletterofthefunctionyouwantto
find.DesktopIntelligencehighlightsthefirstfunctionbeginningwiththat
letter.
Usingthefunctionhelp
Beforeworkingwithafunctionforthefirsttime,usetheFunctionHelptofind
outwhatthefunctiondoes.
• SelectthefunctionintheFunctionslistandclicktheFunctionHelpbutton.
Thehelppagegivesadescriptionofthefunction,itssyntax,andan
example.
306
DesktopIntelligenceAccessandAnalysisGuide
Formulas,LocalVariablesandFunctions
18
Functions