Minimum


 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — —
Sup­port machine trans­la­tion: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — —















Crys­tal Reports Online Help
Min­im­um
Basic and Crys­tal syn­tax.
Over­loads
Min­im­um (fld)
Min­im­um (fld, cond­Fld)
Min­im­um (fld, cond­Fld, cond)
Min­im­um (x)
Argu­ments
fld is any val­id data­base or for­mu­la field that can be eval­u­ated by the func­tion.
cond­Fld is a field used to group the val­ues in fld by.
cond is a String indic­at­ing the type of group­ing for cond­Fld. You only spe­cify this argu­ment when cond­Fld is a Date, Time, Dat­e­Time or Boolean field. For more inform­a­tion on the val­id strings for this argu­ment, see Con­di­tions for sum­mary func­tions .
x is an array or range of val­ues that can be eval­u­ated by the func­tion being used.
Returns
Frac­tion­al Num­ber
Action
Enables you to find the min­im­um value that appears in a set of val­ues. For example:
If a sales report includes a field that shows the amount of each order, you can find the lowest order amount of all the orders that appear on the report (a grand total min­im­um amount).
If you break orders into groups (for example, orders grouped by the state that they come from), you can find the lowest 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 lowest order amount per group based on a spe­cific change in the date or Boolean field (in this case, per month).
If you spe­cify a set of indi­vidu­al val­ues, you can find the lowest value in the set. For inform­a­tion on find­ing this kind of min­im­um, see Array sum­mary func­tions .
Examples
The fol­low­ing examples are applic­able to both Basic and Crys­tal syn­tax:
Minimum({file.QTY})Returns the lowest value in the QTY field.
Minimum({orders.AMOUNT}, {orders.CUSTOMER ID})Identifies the smal­lest order in each group of orders in the Amount field (the smal­lest order for each cus­tom­er). The orders are sep­ar­ated into groups whenev­er the value in the Cus­tom­er ID field changes.
Minimum({orders.AMOUNT}, {orders.ORDER DATE}, ““monthly””)Identifies the smal­lest order in each group of orders in the Amount field (the smal­lest order for each month). The orders are sep­ar­ated into groups whenev­er the value in the Date field changes to a new month.
The fol­low­ing example is applic­able to Crys­tal syn­tax:
Min­im­um also allows you to set a ceil­ing on a cal­cu­la­tion. For example: Min­im­um([{file.COMMISSION}, 2500]) returns the com­mis­sion accrued up to a cap or ceil­ing of 2500. Once accrued com­mis­sion passes the $2500 mark, this expres­sion returns 2500. Thus:
Min­im­um([{file.COMMISSION}, 2500])Returns 1575 where com­mis­sion = 1575.
Note:
Using this func­tion in a for­mu­la forces the for­mu­la to be eval­u­ated at print time. For more inform­a­tion on eval­u­ation time con­sid­er­a­tions, see Eval­u­ation Time.
When using this func­tion, you can use the HasLower­Bound (x) func­tion to test if the range will have a Min­im­um before tak­ing the Min­im­um.
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –

Pre­vi­ous page Next page
SAP Busi­nessOb­jects
http://www.sap.com/sapbusinessobjects/
Sup­port ser­vices
http://service.sap.com/bosap-support/
Pro­duct Doc­u­ment­a­tion on the Web
http://help.sap.com/


 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Appoġġ ta traduzz­joni awto­matika: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –

Rap­porti Crys­tal Online Għa­jnuna
min­imu
Bażiku u Crys­tal sin­tassi.
kariki żejda
Min­imu (FLD)
Min­imu (FLD, cond­Fld)
Min­imu (FLD, cond­Fld, cond)
Min­imu (x)
argu­menti
FLD hija kwalunk­we data­base jew for­mu­la qasam val­ida li jist­għu jiġu eval­wati mill-fun­z­joni.
cond­Fld huwa qasam użata biex jag­grup­paw il-valuri fil FLD by.
cond hija String jindika t-tip ta grupp għall cond­Fld. Inti biss tis­peċi­fika dan l-argu­ment meta cond­Fld huwa Data, Ħin, Dat­e­Time jew qasam Boolean. Għal aktar inform­azz­joni dwar il-kordi val­idi għal dan l-argu­ment, ara Kondizz­jon­iji­et għal fun­z­jon­iji­et fil-qosor.
x hija firxa jew firxa ta valuri li jist­għu jiġu eval­wati mill-fun­z­joni qed jin­tużaw.
denun­zji
Num­ru frazz­jon­ali
azz­joni
Tip­per­met­tilek li ssib il-valur min­imu li tid­her fil-sett ta valuri. Pereżem­pju:
Jekk rap­port ta bejgħ jinkludi qasam li turi l-ammont ta’ kull ord­ni, tista ssib l-ammont ord­ni baxx ta’ l-ord­niji­et koll­ha li jidhru fuq ir-rap­port (ammont min­imu total sħiħ).
Jekk inti tikser l-ord­niji­et fi grup­pi (pereżem­pju, ord­niji­et rag­grup­pati mill-istat li jkunu ġejjin minn), tista ssib l-ammont aktar baxx ord­ni għal kull grupp (f’dan il-każ, kull stat).
Jekk inti tikser l-ord­niji­et fi data jew Boolean grup­pi (pereżem­pju, ord­niji­et rag­grup­pati mill-xahar li fih ikunu tqiegħ­du), tista ssib l-ammont ord­ni aktar baxx għal kull grupp ibbażat fuq bid­la speċi­fika fil – data jew qasam Boolean (f’dan il-każ, kull xahar).
Jekk inti tis­peċi­fika sett ta valuri indi­vid­wali, tista’ ssib l-inqas valur fis-sett. Għal tagħrif dwar is-sejba dan it-tip ta min­imu, ara fun­z­jon­iji­et som­marji Array.
eżem­pji
L-eżem­pji li ġejjin huma app­likab­bli kemm sin­tassi Bażiku u Crys­tal:
Min­imu ({file.QTY}) Denun­zji l-inqas valur fil-qasam Qty.
Min­imu ({orders.AMOUNT}, {orders.CUSTOMER ID}) Jiden­ti­fika l-iżgħar ord­ni f’kull grupp ta ord­niji­et fil-qasam Ammont (l-iżgħar ord­ni għal kull klijent). L-ord­niji­et huma sep­ar­ati fi grup­pi kull meta l-valur fit-tib­dil qasam Klijent ID.
Min­imu ({orders.AMOUNT}, {orders.ORDER DATA}, ““kull xahar””) Jiden­ti­fika l-iżgħar ord­ni f’kull grupp ta ord­niji­et fil-qasam Ammont (l-iżgħar ord­ni għal kull xahar). L-ord­niji­et huma sep­ar­ati fi grup­pi kull meta l-valur fil-qasam Data bid­li­et għal xahar ġdid.
L-eżem­pju li ġej huwa app­likab­bli għal sin­tassi Crys­tal:
Min­imu tip­per­met­ti wkoll li inti jiff­is­saw lim­itu massimu fuq kalkolu. Per eżem­pju: Min­imu ([{file.COMMISSION}, 2500]) jir­rit­or­na l-kum­mis­s­joni akku­mu­lat sa lim­itu jew lim­itu ta ‘2500. kum­mis­s­joni Ladar­ba akku­mu­lat jgħad­di l-marka $ 2500, din l-espress­joni pros­pet­ti 2500. Għal­hekk:
Min­imu ([{file.COMMISSION}, 2500]) Denun­zji 1575 fejn kum­mis­s­joni = 1575.
Nota:
Meta tuża din il-fun­z­joni fil-for­mu­la Forzi il-for­mu­la li jiġu eval­wati fil-ħin istam­par. Għal aktar inform­azz­joni dwar kun­sid­erazz­jon­iji­et ta żmi­en ta’ valutazz­joni, ara Eval­wazz­joni Ħin.
Meta tuża din il-fun­z­joni, inti tista tuża l-HasLower­Bound (x) il-fun­z­joni li jit­testjaw jekk il-med­da se jkoll­ha min­imu qabel tieħu l-min­imu.
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  — —

paġna ta qabel paġna li jmiss
SAP Busi­nessOb­jects
http://www.sap.com/sapbusinessobjects/
ser­vizzi ta appoġġ
http://service.sap.com/bosap-support/
Dok­u­mentazz­joni pro­dott fuq il-Web
http://help.sap.com/
 


 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Onder­steun­ing masji­en ver­tal­ing: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –

Crys­tal Reports Online Hulp
min­im­um
Basiese en Crys­tal sin­tak­s­is.
oor­laai
Min­im­um (FLD)
Min­im­um (FLD, cond­Fld)
Min­im­um (FLD, cond­Fld olv)
Min­im­um (x)
argu­mente
fld is geen geldige data­bas­is of for­mule in die veld wat geë­valueer kan word deur die funk­sie.
cond­Fld is n stuk grond wat gebruik word om groep die waardes in fld deur.
olv n String dui die tipe groep­er­ing vir cond­Fld. Jy gee net hierdie argu­ment wan­neer cond­Fld is n datum, tyd, Datum tyd of Boole veld. Vir meer inligt­ing oor die geldige snare vir hierdie argu­ment, sien Voor­waardes vir opso­m­ming funk­sies.
x is n skikking of reeks waardes wat geë­valueer kan word deur die funk­sie gebruik word.
opbreng­ste
frak­sionele nom­mer
Aksie
In staat stel om die min­im­um waarde wat in n stel waardes blyk vind. Byvoor­beeld:
As n verko­pe verslag sluit in n veld wat die bedrag van elke bestelling toon, kan jy die laag­ste orde bedrag van al die bestellings wat op die verslag ( n groot­totaal min­im­um bedrag) ver­skyn vind.
As jy bestellings in groepe te breek (byvoor­beeld bestellings gegroep­eer deur die staat wat hulle vandaan kom), kan jy die laag­ste orde bedrag per groep (in hierdie geval, per staat) te vind.
As jy bestellings in datum of Boole groepe te breek (byvoor­beeld bestellings gegroep­eer deur die maand waar­in hulle gep­laas is), kan jy die laag­ste orde bedrag per groep op grond van n spesi­fieke ver­an­der­ing in die datum of Boole veld (in hierdie geval, per maand).
As jy n stel van indi­viduele waardes spesi­fiseer, kan jy die laag­ste waarde in die stel te vind. Vir meer inligt­ing oor die vind van hierdie soort min­im­um, sien opso­m­ming Array funk­sies.
voor­beelde
Die vol­gende voor­beelde is van toe­p­assing op beide basiese en Crys­tal sin­tak­s­is:
Min­im­um ({file.QTY}) gee ter­ug Die laag­ste waarde in die veld HOEV.
Min­im­um ({orders.AMOUNT}, {orders.CUSTOMER ID}) iden­ti­fiseer die klein­ste orde in elke groep van bestellings in die veld Bedrag (die klein­ste sod­at elke kliënt). Die bestellings word ver­deel in groepe wan­neer die waarde in die kliënt ID veld ver­an­deringe.
Min­im­um ({orders.AMOUNT}, {orders.ORDER date}, ““maan­deliks””) iden­ti­fiseer die klein­ste orde in elke groep van bestellings in die veld Bedrag (die klein­ste einde vir elke maand). Die bestellings word ver­deel in groepe wan­neer die waarde in die veld Datum ver­ander na n nuwe maand.
Die vol­gende voor­beeld is van toe­p­assing op Crys­tal sin­tak­s­is:
Min­im­um kan jy ook n pla­fon op n berek­en­ing. Byvoor­beeld: Min­im­um ([{file.COMMISSION}, 2500]) gee ter­ug Die kom­mis­sie toegeval tot n pet of pla­fon van 2500. Sodra toegeval kom­mis­sie gaan die $ 2500 merk, hierdie uit­drukking ter­ug 2500. Dus:
Min­im­um ([{file.COMMISSION}, 2500]) gee ter­ug 1575 waar kom­mis­sie = 1575.
Nota:
Die gebruik van hierdie funk­sie in n for­mule magte die for­mule om geë­valueer te druk tyd. Vir meer inligt­ing oor eval­u­er­ing tyd oor­we­gings, sien Eval­u­er­ing Tyd.
By die gebruik van hierdie funk­sie, kan jy die funk­sie HasLower­Bound (x) te gebruik om te toets of die reeks n Min­im­um voord­at die Min­im­um sal hê.
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  — —