Ë®¾§±¨±íº¯Êý´óÈ«-»ã×ܺ¯Êý ÏÂÔØ±¾ÎÄ

СÊýÊý×Ö

²Ù×÷

ʹÄúÄܹ»¼ÆËãÖ¸¶¨×ֶεļÓȨƽ¾ùÖµ¡£ÔÚ¼ÆËã¼ÓȨƽ¾ùֵʱ£¬Êµ¼ÊÉÏÊǼÆËãÒ»¸ö×Ö¶ÎµÄÆ½¾ùÖµ£¬È»ºóʹÓÃÁíÒ»¸ö×ֶεÄÖµÀ´¶ÔµÚÒ»¸ö×Ö¶ÎÖеÄÿ¸öÖµÔÚÆ½¾ùÖµÖеÄ×÷ÓýøÐС°¼ÓȨ¡±¡£ÔÚÒ»°ãµÄƽ¾ùÖµÖУ¬ËùÓÐȨÊý¶¼µÈÓÚ 1¡£ ÀýÈ磺

? ? ?

Äú¿ÉÒÔ¼ÆËãÁ½¸ö×ֶεļÓȨƽ¾ùÖµ¡£

Äú¿ÉÒÔ¶Ôij¸ö×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÀ´×ÔµÄÊ¡½øÐзÖ×飩µÄËùÓÐÖµ¼ÆËãÁ½¸ö×ֶεļÓȨƽ¾ùÖµ¡£

Äú¿ÉÒÔ¶ÔÆä·Ö×éÓÉÈÕÆÚ»ò²¼¶û×Ö¶ÎÖеı仯½øÐпØÖƵÄ×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÍê³ÉµÄÔ·ݽøÐзÖ×飩ÖеÄËùÓÐÖµ¼ÆËãÁ½¸ö×ֶεļÓȨƽ¾ùÖµ¡£

ʾÀý

ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º

WeightedAverage({table.FIELD1}, {table.FIELD2})

·µ»Ø 3.5£¬ÆäÖÐÁ½¸ö×Ö¶ÎÖÐÿ¸ö×ֶζ¼ÓÐËĸöÖµ¡£Field1 ¾ßÓÐÖµ 3¡¢2¡¢5 ºÍ 1¡£Field2 ¾ßÓÐÖµ 0¡¢1¡¢1 ºÍ 0¡£WeightedAverage ¼ÆËãÈçÏ£º(3*0 + 2*1 + 5*1 + 1*0)/sum{table.FIELD2}) = 3.5¡£

×¢Ò⣺ ÔÚ¹«Ê½ÖÐʹÓô˺¯ÊýÇ¿ÖÆÔÚ´òӡʱ¶Ô¹«Ê½ÇóÖµ¡£ÓйØÇóֵʱ¼ä¿¼ÂÇÒòËØµÄÏêϸÐÅÏ¢£¬²Î¼ûÇóֵʱ¼ä¡£

Median

Basic Óï·¨ºÍ Crystal Óï·¨¡£

ÖØÔØ

? ? ?

²ÎÊý

Median (fld) Median (fld, condFld) Median (fld, condFld, cond)

? ?

fld ÊÇ¿ÉÓɺ¯ÊýÇóÖµµÄÈκÎÓÐЧµÄÊý¾Ý¿â×ֶλò¹«Ê½×ֶΡ£ condFld ÊÇÓÃÓÚ¶Ô fld ÖеÄÖµ½øÐзÖ×éʱËùÒÀ¾ÝµÄ×ֶΡ£

? cond ÊDZíÃ÷ condFld ·Ö×éÀàÐ͵Ä×Ö·û´®¡£Ö»ÄÜÔÚ condFld ÊÇÒ»¸öÈÕÆÚ¡¢Ê±¼ä¡¢ÈÕÆÚʱ¼ä»ò²¼¶û×Ö¶Îʱ²ÅÖ¸¶¨´Ë²ÎÊý¡£Óйش˲ÎÊýÓÐЧ×Ö·û´®µÄÏêϸÐÅÏ¢£¬²Î¼û»ã×ܺ¯ÊýµÄÌõ¼þ¡£

·µ»Ø

СÊýÊý×Ö

²Ù×÷

¼ÆËã¸ø¶¨ÊýÖµ×ֶεÄÖÐÖµ¡£ÖÐÖµÊÇÖ¸Ò»¸öÊýÖµÐòÁÐÖеÄÖмäÖµ£¨»òÕßÊÇÒ»¸öżÊýÐòÁÐÖµÖÐÁ½¸öÖмäÖµµÄƽ¾ùÖµ£©¡£ ÀýÈ磺

? ? ?

ʾÀý

Äú¿ÉÒÔ¼ÆËãij¸ö×Ö¶ÎÖÐËùÓÐÖµµÄÖÐÖµ¡£

Äú¿ÉÒÔ¼ÆËãij¸ö×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÀ´×ÔµÄÊ¡½øÐзÖ×飩µÄÒ»¸ö×Ö¶ÎÖÐËùÓÐÖµµÄÖÐÖµ¡£

Äú¿ÉÒÔ¼ÆËãÆä·Ö×éÓÉÈÕÆÚ»ò²¼¶û×Ö¶ÎÖеı仯½øÐпØÖƵÄ×飨ÀýÈ磬¶ÔÏúÊÛ°´ÆäÍê³ÉµÄÔ·ݽøÐзÖ×飩ÄÚËùÓÐÖµµÄÖÐÖµ¡£

ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º

Median({¿Í»§.È¥ÄêÏúÊÛ¶î})

·µ»Ø $29087£¬ÆäÖС°È¥ÄêÏúÊ۶×ֶεÄֵΪ $27014¡¢$28000¡¢$29087¡¢$34500 ºÍ $48260¡£

Median({¿Í»§.È¥ÄêÏúÊÛ¶î}, {¿Í»§.µØÇø)

¶Ô¡°È¥ÄêÏúÊ۶×ֶΰ´µØÇø½øÐзÖ×飬²¢·µ»ØÃ¿¸öµØÇø¡°È¥ÄêÏúÊ۶×ֶεÄÖÐÖµ¡£

Median({¶©µ¥.¶©µ¥½ð¶î}, {¿Í»§.µØÇø}, \

¶Ô¡°½ð¶î¡±×Ö¶ÎÖеÄÖµ°´µØÇø½øÐзÖ×飬Ȼºó·µ»ØÃ¿ÔÂÖÐÿ¸öµØÇø¶©µ¥½ð¶îµÄÖÐÖµ¡£

×¢Ò⣺ ÔÚ¹«Ê½ÖÐʹÓô˺¯ÊýÇ¿ÖÆÔÚ´òӡʱ¶Ô¹«Ê½ÇóÖµ¡£

ÓйØÇóֵʱ¼ä¿¼ÂÇÒòËØµÄÏêϸÐÅÏ¢£¬²Î¼ûÇóֵʱ¼ä¡£ PthPercentile

Basic Óï·¨ºÍ Crystal Óï·¨¡£

ÖØÔØ

? ? ?

²ÎÊý

PthPercentile (P, fld) PthPercentile (P, fld, condFld) PthPercentile (P, fld, condFld, cond)

? ? ? ?

P ÊǽéÓÚ 0 ºÍ 100 Ö®¼äµÄÈκÎÕûÊý¡£ fld ÊÇ¿ÉÓɺ¯ÊýÇóÖµµÄÈκÎÊý×Ö×ֶλò»õ±Ò×ֶΡ£ condFld ÊÇÓÃÓÚ¶Ô fld ÖеÄÖµ½øÐзÖ×éʱËùÒÀ¾ÝµÄ×ֶΡ£

cond ÊDZíÃ÷ condFld ·Ö×éÀàÐ͵Ä×Ö·û´®¡£Ö»ÄÜÔÚ condFld ÊÇÒ»¸öÈÕÆÚ¡¢Ê±¼ä¡¢ÈÕÆÚʱ¼ä»ò²¼¶û×Ö¶Îʱ²ÅÖ¸¶¨´Ë²ÎÊý¡£ Óйش˲ÎÊýÓÐЧ×Ö·û´®µÄÏêϸÐÅÏ¢£¬²Î¼û»ã×ܺ¯ÊýµÄÌõ¼þ¡£

·µ»Ø

Êý×Ö»ò»õ±ÒÖµ

²Ù×÷

¼ÆËãÊý×Ö×ֶλò»õ±Ò×Ö¶ÎÖÐÖ¸¶¨°Ù·Öλ (P) µÄÖµ¡£

ʾÀý

ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º

PthPercentile(20, {¿Í»§.È¥ÄêÏúÊÛ¶î})

·µ»Ø $2302 ×÷ΪµÚ 20 ¸ö°Ù·ÖλµÄÖµ£¨Èç¹û {¿Í»§.È¥ÄêÏúÊÛ¶î} µÄ 20% СÓÚ $2302£©¡£

PthPercentile(P, {¿Í»§.È¥ÄêÏúÊÛ¶î}, {¿Í»§.µØÇø})

¶Ô¡°È¥ÄêÏúÊ۶×ֶΰ´µØÇø½øÐзÖ×飬²¢·µ»ØÃ¿¸öµØÇø¡°È¥ÄêÏúÊ۶×Ö¶ÎÖаٷÖλ P Öµ¡£

PthPercentile(P,{¶©µ¥.¶©µ¥½ð¶î}, {¿Í»§.µØÇø}, \

¶Ô¡°½ð¶î¡±×Ö¶ÎÖеÄÖµ°´µØÇø½øÐзÖ×飬Ȼºó·µ»ØÃ¿ÔÂÿ¸öµØÇøµÄ¡°½ð¶î¡±×ֶεİٷÖλ P Öµ¡£

×¢ÊÍ

µ± P = 50£¨µÚ 50 ¸ö°Ù·Öλ£©Ê±·µ»ØµÄÖµÓë Median º¯Êý£¨ÖÐÖµ£©·µ»ØµÄÖµÏàͬ¡£

×¢Ò⣺ ÔÚ¹«Ê½ÖÐʹÓô˺¯ÊýÇ¿ÖÆÔÚ´òӡʱ¶Ô¹«Ê½ÇóÖµ¡£

ÓйØÇóֵʱ¼ä¿¼ÂÇÒòËØµÄÏêϸÐÅÏ¢£¬²Î¼ûÇóֵʱ¼ä¡£ NthLargest

Basic Óï·¨ºÍ Crystal Óï·¨¡£

ÖØÔØ

? ? ?

²ÎÊý

NthLargest (N, fld) NthLargest (N, fld, condFld) NthLargest (N, fld, condFld, cond)

? ? ? ?

N ÊÇ´Ó 1 µ½ 100 Ö®¼ä£¨°üÀ¨ 1 ºÍ 100£©µÄÈκÎÕûÊý¡£ fld ÊÇ¿ÉÓɺ¯ÊýÇóÖµµÄÈκÎÓÐЧµÄÊý¾Ý¿â×ֶλò¹«Ê½×ֶΡ£ condFld ÊÇÓÃÓÚ¶Ô fld ÖеÄÖµ½øÐзÖ×éʱËùÒÀ¾ÝµÄ×ֶΡ£

cond ÊDZíÃ÷ condFld ·Ö×éÀàÐ͵Ä×Ö·û´®¡£Ö»ÄÜÔÚ condFld ÊÇÒ»¸öÈÕÆÚ¡¢Ê±¼ä¡¢ÈÕÆÚʱ¼ä»ò²¼¶û×Ö¶Îʱ²ÅÖ¸¶¨´Ë²ÎÊý¡£Óйش˲ÎÊýÓÐЧ×Ö·û´®µÄÏêϸÐÅÏ¢£¬²Î¼û»ã×ܺ¯ÊýµÄÌõ¼þ¡£

·µ»Ø

СÊýÊý×Ö

²Ù×÷

È·¶¨Õû¸ö±¨±í»òÿ¸ö (condFld) ×éʵÀýÖиø¶¨×Ö¶ÎµÄµÚ N ¸ö×î´óÖµ¡£

ʾÀý

ÏÂÁÐʾÀýÊÊÓÃÓÚ Basic Óï·¨ºÍ Crystal Óï·¨£º

NthLargest(1, {¿Í»§.¿Í»§ ID}

·µ»Ø 50£¬ÆäÖС°¿Í»§ ID¡±×ֶΰüº¬·¶Î§´Ó 12 µ½ 50 µÄÊýÖµ¡£

NthLargest(5, {¿Í»§.¿Í»§ÐÕÃû}, {¿Í»§.µØÇø})

·µ»ØÃ¿¸öµØÇøÖС±¿Í»§Ãû³Æ¡±×Ö¶ÎµÄµÚ 5 ¸ö×î´óÖµ¡£