Maximum

Facebooktwittergoogle_plusredditpinterestlinkedinmailby feather


——————————————————————————————————————————————————
Support machine translation: http://amzn.to/1Z7d5oc
——————————————————————————————————————————————————

Crystal Reports Online Help
Maximum
Basic and Crystal syntax.
Overloads
Maximum (fld)
Maximum (fld, condFld)
Maximum (fld, condFld, cond)
Maximum (x)
Arguments
fld is any valid database or formula field that can be evaluated by the function.
condFld is a field used to group the values in fld by.
cond is a String indicating the type of grouping for condFld. You only specify this argument when condFld is a Date, Time, DateTime or Boolean field. For more information on the valid strings for this argument, see Conditions for summary functions .
x is an array or range of values that can be evaluated by the function being used.
Returns
Number
Action
Enables you to find the maximum value that appears in a set of values. For example:
If a sales report includes a field that shows the amount of each order, you can find the highest order amount of all the orders that appear on the report (a grand total maximum amount).
If you break orders into groups (for example, orders grouped by the state that they come from), you can find the highest order amount per group (in this case, per state).
If you break orders into date or Boolean groups (for example, orders grouped by the month in which they were placed), you can find the highest order amount per group based on a specific change in the date or Boolean field (in this case, per month).
If you specify a set of individual values, you can find the highest value in the set. For information on finding this kind of maximum, see Array summary functions .
Examples
The following examples are applicable to both Basic and Crystal syntax:
Maximum({orders.ORDER AMOUNT})Returns the highest value in the Amount field.
Maximum({orders.AMOUNT}, {orders.CUSTOMER ID})Identifies the largest order in each group of orders in the Amount field (the largest order for each customer). The orders are separated into groups whenever the value in the Customer ID field changes.
Maximum({orders.AMOUNT}, {orders.ORDER DATE}, “”monthly””)Identifies the largest order in each group of orders in the Amount field (the largest order for each month). The orders are separated into groups whenever the value in the Date field changes to a new month.
The following example is applicable to Crystal syntax:
Maximum also allows you to set a floor on a calculation. For example: Maximum([{file.BALANCE}, 500]) sets a floor of 500 on the calculation. The expression will always return the balance unless the balance drops below 500. Then it will return the floor amount of 500. Thus:
Maximum([{file.PROFITS}, 500]) = {file.PROFITS}Where Profits > 500.
Note:
Using this function in a formula forces the formula to be evaluated at print time. For more information on evaluation time considerations, see Evaluation Time.
When using this function, you can use the HasUpperBound (x) function to test if the range will have a Maximum before taking the Maximum.
——————————————————————————–

Previous page Next page
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/


————————————————– ————————————————– ————————————————–
Appoġġ ta ‘traduzzjoni awtomatika: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

Rapporti Crystal Online Għajnuna
massimu
Bażiku u Crystal sintassi.
kariki żejda
Massimu (FLD)
Massimu (FLD, condFld)
Massimu (FLD, condFld, cond)
Massimu (x)
argumenti
FLD hija kwalunkwe database jew formula qasam valida li jistgħu jiġu evalwati mill-funzjoni.
condFld huwa qasam użata biex jaggruppaw il-valuri fil FLD by.
cond hija String jindika t-tip ta ‘grupp għall condFld. Inti biss tispeċifika dan l-argument meta condFld huwa Data, Ħin, DateTime jew qasam Boolean. Għal aktar informazzjoni dwar il-kordi validi għal dan l-argument, ara Kondizzjonijiet għal funzjonijiet fil-qosor.
x hija firxa jew firxa ta ‘valuri li jistgħu jiġu evalwati mill-funzjoni qed jintużaw.
denunzji
numru
azzjoni
Tippermettilek li ssib il-valur massimu li jidher fil-sett ta ‘valuri. Pereżempju:
Jekk rapport ta ‘bejgħ jinkludi qasam li turi l-ammont ta’ kull ordni, inti tista ‘ssib l-ogħla ammont ordni tal-ordnijiet kollha li jidhru fuq ir-rapport (ammont massimu total sħiħ).
Jekk inti tikser l-ordnijiet fi gruppi (pereżempju, ordnijiet raggruppati mill-istat li jkunu ġejjin minn), tista ‘ssib l-ogħla ammont ordni għal kull grupp (f’dan il-każ, kull stat).
Jekk inti tikser l-ordnijiet fi data jew Boolean gruppi (pereżempju, ordnijiet raggruppati mill-xahar li fih ikunu tqiegħdu), tista ‘ssib l-ogħla ammont ordni għal kull grupp ibbażat fuq bidla speċifika fil–data jew qasam Boolean (f’dan il-każ, kull xahar).
Jekk inti tispeċifika sett ta ‘valuri individwali, tista’ ssib l-ogħla valur fis-sett. Għal tagħrif dwar is-sejba dan it-tip ta massima, ara funzjonijiet sommarji Array.
eżempji
L-eżempji li ġejjin huma applikabbli kemm sintassi Bażiku u Crystal:
Massimu ({AMMONT orders.ORDER}) Denunzji l-ogħla valur fil-qasam Ammont.
Massimu ({orders.AMOUNT}, {orders.CUSTOMER ID}) Jidentifika l-ordni akbar f’kull grupp ta ‘ordnijiet fil-qasam Ammont (l-ikbar ordni għal kull klijent). L-ordnijiet huma separati fi gruppi kull meta l-valur fit-tibdil qasam Klijent ID.
Massimu ({orders.AMOUNT}, {orders.ORDER DATA}, “”kull xahar””) Jidentifika l-ordni akbar f’kull grupp ta ‘ordnijiet fil-qasam Ammont (l-ikbar ordni għal kull xahar). L-ordnijiet huma separati fi gruppi kull meta l-valur fil-qasam Data bidliet għal xahar ġdid.
L-eżempju li ġej huwa applikabbli għal sintassi Crystal:
Massimu tippermetti wkoll li inti biex jistabbilixxu limitu minimu fuq kalkolu. Per eżempju: Massimu ([{file.BALANCE}, 500]) tistabbilixxi art ta ‘500 fuq il-kalkolu. L-espressjoni dejjem se terġa ‘lura l-bilanċ sakemm il-bilanċ taqa’ taħt 500. Imbagħad se jirritorna l-ammont art ta 500. Għalhekk:
Massimu ([{file.PROFITS}, 500]) = {file.PROFITS} Fejn Profitti> 500.
Nota:
Meta tuża din il-funzjoni fil-formula Forzi il-formula li jiġu evalwati fil-ħin istampar. Għal aktar informazzjoni dwar kunsiderazzjonijiet ta ‘żmien ta’ valutazzjoni, ara Evalwazzjoni Ħin.
Meta tuża din il-funzjoni, inti tista ‘tuża l-HasUpperBound (x) il-funzjoni li jittestjaw jekk il-medda se jkollha massimu qabel tieħu l-massimu.
————————————————– ——————————

paġna ta ‘qabel paġna li jmiss
SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
servizzi ta ‘appoġġ
http://service.sap.com/bosap-support/
Dokumentazzjoni prodott fuq il-Web
http://help.sap.com/
 


————————————————– ————————————————– ————————————————–
Ondersteuning masjien vertaling: http://amzn.to/1Z7d5oc
————————————————– ————————————————– ————————————————–

Crystal Reports Online Hulp
maksimum
Basiese en Crystal sintaksis.
oorlaai
Maksimum (FLD)
Maksimum (FLD, condFld)
Maksimum (FLD, condFld olv)
Maksimum (x)
argumente
fld is geen geldige databasis of formule in die veld wat geëvalueer kan word deur die funksie.
condFld is ‘n stuk grond wat gebruik word om groep die waardes in fld deur.
olv ‘n String dui die tipe groepering vir condFld. Jy gee net hierdie argument wanneer condFld is ‘n datum, tyd, Datum tyd of Boole veld. Vir meer inligting oor die geldige snare vir hierdie argument, sien Voorwaardes vir opsomming funksies.
x is ‘n skikking of reeks waardes wat geëvalueer kan word deur die funksie gebruik word.
opbrengste
nommer
Aksie
In staat stel om die maksimum waarde wat in ‘n stel waardes blyk vind. Byvoorbeeld:
As ‘n verkope verslag sluit in ‘n veld wat die bedrag van elke bestelling toon, kan jy die hoogste orde bedrag van al die bestellings wat op die verslag ( ‘n groottotaal bedrag maksimum) verskyn vind.
As jy bestellings in groepe te breek (byvoorbeeld bestellings gegroepeer deur die staat wat hulle vandaan kom), kan jy die hoogste orde bedrag per groep (in hierdie geval, per staat) te vind.
As jy bestellings in datum of Boole groepe te breek (byvoorbeeld bestellings gegroepeer deur die maand waarin hulle geplaas is), kan jy die hoogste orde bedrag per groep op grond van ‘n spesifieke verandering in die datum of Boole veld (in hierdie geval, per maand).
As jy ‘n stel van individuele waardes spesifiseer, kan jy die hoogste waarde in die stel te vind. Vir meer inligting oor die vind van hierdie soort maksimum, sien opsomming Array funksies.
voorbeelde
Die volgende voorbeelde is van toepassing op beide basiese en Crystal sintaksis:
Maksimum ({orders.ORDER BEDRAG}) gee terug Die grootste waarde in die veld Bedrag.
Maksimum ({orders.AMOUNT}, {orders.CUSTOMER ID}) identifiseer die grootste orde in elke groep van bestellings in die veld Bedrag (die grootste orde vir elke kliënt). Die bestellings word verdeel in groepe wanneer die waarde in die kliënt ID veld veranderinge.
Maksimum ({orders.AMOUNT}, {orders.ORDER date}, “”maandeliks””) identifiseer die grootste orde in elke groep van bestellings in die veld Bedrag (die grootste orde vir elke maand). Die bestellings word verdeel in groepe wanneer die waarde in die veld Datum verander na ‘n nuwe maand.
Die volgende voorbeeld is van toepassing op Crystal sintaksis:
Maksimum kan jy ook ‘n vloer op ‘n berekening. Byvoorbeeld: Maksimum ([{file.BALANCE}, 500]) stel ‘n vloer van 500 op die berekening. Die uitdrukking sal altyd die balans terug te keer nie, tensy die balans druppels hieronder 500. Dan sal dit die vloer bedrag van 500. So terugkeer:
Maksimum ([{file.PROFITS}, 500]) = {file.PROFITS} Waar Winste> 500.
Nota:
Die gebruik van hierdie funksie in ‘n formule magte die formule om geëvalueer te druk tyd. Vir meer inligting oor evaluering tyd oorwegings, sien Evaluering Tyd.
By die gebruik van hierdie funksie, kan jy die funksie HasUpperBound (x) te gebruik om te toets of die reeks ‘n maksimum sal voor die neem van die maksimum.
————————————————– ——————————

Facebooktwittergoogle_plusredditpinterestlinkedinmailby feather