Moving average function in cognos

Zwraca obliczoną wartość przy użyciu odpowiedniej funkcji agregowania, w oparciu o typ agregacji wyrażenia. Składnia: aggregate (expr auto) aggregate (expr dla wszystkich wszystkich expr) aggregate (expr for report) Count: Zwraca liczbę wybranych elementów danych, z wyjątkiem wartości NULL. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: liczenie (odrębne wyrażenie) liczenie (odrębne wyrażenie dla wszystkich dowolnych wartości) liczenie (odrębne wyrażenie dla raportu) Przykład: liczba (gosalesgoretailers. Products. Product name) - (op: 41, 15, 21) Count (Typ produktu dla wszystkie Product line) ------------ (op: 5, 4, 4) Count (typ produktu dla dowolnej linii produktów) ----------- (op: 5, 4, 4) Liczba (Typ produktu dla raportu) ------------------- (op .: 21 dla wszystkich) Maksymalnie: Zwraca maksymalną wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: maksymalny (odrębny expr auto) maksymalny (odrębny expr dla wszystkich wszystkich expr) maksimum (odrębny expr dla raportu) Przykład: maximum (Quantity) -------------------- ------------ (op: 962) maks. (Ilość dla wszystkich gosalesgoretailers. Products. Product type) (op: 344,4368230) Maximum (Ilość dla każdego gosalesgoretailers. Products. Product name) (op. : 44,78,8230.) Maximum (Ilość raportu) ------------------- (op: 1,646) Minimum: Zwraca minimalną wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: minimalny (odrębny expr auto) minimum (odrębny expr dla wszystkich wszystkich expr) minimum (odrębny expr dla raportu) Przykład: minimum (Ilość) -------------- (op: 43,330, 142,150 Minimalna ilość (dla każdego typu produktu) ---- (op: 6, 4, 4, 8230.) Minimalny (Ilość na dowolny typ produktu) 8211 (op: 6, 4, 4.) Minimalna ilość (w raporcie) ----------------- (op: 2) Moving-Average: Zwraca wartość, dodając wartości do poprzedniej w oparciu o numericexp. Składnia: średnia ruchoma (numericexpr. Numericexpr w filtrze wstępnym exp) średnica ruchoma (odrębny numericexpr. Numericexpr filtr wstępny). dla wyrażenia dla raportu auto Przykład: średnia ruchoma (ilość, 2) (op: ilość średnia ruchoma 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Ruchome sumy: Zwraca wartość dodając wartości do poprzedniej na podstawie składowej liczbicexp: (liczba, 3) Wyjście: Ilość Średnia ruchoma 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 (łącznie z liczbą całkowitą) w liczbie całkowitej (numericexpr. numericexpr w filtrze wstępnym exp) Procent: Zwraca procent całkowitej wartości dla wybranych elementów danych. Używany tylko w relacyjnych źródłach danych Składnia: procentowy (liczbicexpr przy exp filtru) procentowy (różny licznik liczbicexpr) dla expr dla raportu auto Przykład: procent (ilość) - ( op: 16, 12, 10). Procent: Zwraca wartość, w skali stu, która wskazuje procent rozkładu, który jest równy lub niższy od wybranych danych przedmiotów. Składnia: percentyl (numericexpr na exp filtru wstępnego) percentyla (odrębny filtr numericexpr). dla wyrażenia dla raportu auto Przykład: percentile (Ilość) -------- (op: 100, 95, 90) Quantile: Zwraca rangę wartości dla określonego zakresu. Zwraca liczbę całkowitą reprezentującą dowolny zakres szeregu, np. 1 (najwyższy) do 100 (najniższy). Składnia: quantile (numericexpr, numericexpr at exp filter) quantile (odrębny numericexpr, filtr liczbicekspr). dla wyrażenia dla raportu auto Przykład: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Kwartyl: Zwraca rangę wartości reprezentowanej jako liczba całkowita od 1 (najwyższa) do 4 ), w stosunku do grupy wartości. Składnia: kwartyl (liczbaicexpr w filtrze wstępnym exp) kwartyl (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: kwartyiel (Ilość) ---------- (op: 1, 2, 3, 4) Zwraca wartość rangi wybranych elementów danych. Jeśli dwa lub więcej wierszy są powiązane, to występuje luka w kolejności rankingowej wartości (znanej również jako ranking olimpijski). Składnia: rank (expr sortorder na exp filtra wstępnego) rank (different expr sortorder prefilter). dla wyrażenia dla raportu auto Przykład: rank Ilość) ----------------- (op: 1, 2, 3, 4, 8230 ..) Zwraca średnią rzędu (w tym bieżący wiersz) dla zestawu wartości Składnia: średnia-średnia (liczbaicexpr w filtrze wstępnym) średnia bieżąca (odrębny filtr wstępny numericexpr). do wyliczenia dla raportu auto Przykład: przeciętna średnia ilość) ------------ (op: ilość Średnia ruchoma 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Liczba biegów: zwraca liczbę biegnącą w wierszu (w tym (bieżący wiersz) dla zbioru wartości Składnia: liczenie-uruchomienie (numericexpr w filtrze wstępnym exp) liczenie uruchomione (oddzielny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: liczenie uruchomieniowe (ilość) ------- (op: 1, 2, 3, 8230) Zwraca bieżącą różnicę w wierszu, liczoną jako różnica między wartością dla bieżącego wiersza a poprzednim wierszem (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: Różnica (numericexpr w filtrze wstępnym exp) Różnica w uruchomieniu (odrębny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: różnica robocza (ilość) - (op: null, 146420, -249,544, 8230 ..) wiersz (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: running-maximum (numericex pr at expfilter) maksymalny (zróżnicowany filtr wstępny numericexpr). dla wartości exr dla raportu auto Przykład: maksimum uruchomienia (Ilość) --------- (op: 198676, 345096) Zwraca bieżące minimum według wiersza (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-minimum (liczbaicexpr w filtrze exp) running-minimum (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: running-minimum (Ilość) --------- (op: 198676, 198676, 95552,) Zwraca bieżącą liczbę wierszy (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-total (numericexpr at expfilter) działa w całości (odrębny filtr wstępny numericexpr). dla expr dla raportu auto Przykład: suma całkowita (ilość) ----------- (op: 198676, 5437728230.) Zwraca standardowe odchylenie wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: odchylenie standardowe (odrębne expr auto) odchylenie standardowe (odrębne wyraŜenie dla wszystkich innych wyraŜeń) odchylenie standardowe (róŜne wartości dla raportu) przykład: odchylenie standardowe (ilość) ------ (op: 50.628, 69.098 8230) odchylenie standardowe (ilość sztuk dla wszystkich typów produktów) -------- (op: 50.628, 69.098, 8230) odchylenie standardowe (ilość na dowolny typ produktu) ------ (op: 50.628, 69.098 8230) odchylenie standardowe (ilość raportu) -------------------- (op: 59.70671027) Raport: odchylenie standardowe Odchylenie standardowe pop: oblicza odchylenie standardowe populacji i zwraca pierwiastek kwadratowy wariancji populacji. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: odchylenie standardowe-pop (odrębne expr auto) odchylenie standardowe-pop (odrębne wyrażenie dla wszystkich innych wartości) odchylenie standardowe-pop (odrębne wyrażenie dla raportu) Przykład: odchylenie standardowe-pop (ilość) ---- (opcjonalnie: 50.62240898, 69.09035128) odchylenie standardowe (ilość sztuk dla wszystkich typów produktów) - (op: 50.62240898, 69.09035128) odchylenie standardowe (ilość na dowolny typ produktu) (op .: 50.62240898, 69.09035128) standard - deviation-pop (Ilość raportu) --- (op: 59.70601702,) Total: Zwraca całkowitą wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: całkowity (odrębny expr auto) całkowity (odrębny expr dla wszystkich wszystkich expr) całkowity (odrębny expr dla raportu) Przykład: total (Quantity) --------------- (op: 198,676, 345,096) Razem (Ilość na wszystkie Typ produktu) ------- (op .: 198,676, 345,096) Razem (Ilość w jakiejkolwiek Typ produktu) ----- (op: 198,676, 345,096) Razem (Ilość w raporcie) --------------- (op: 2215354) Report: Total Variance: Zwraca wariancję wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: variance (different expr auto) wariancja (odrębna wartość wyrażona dla wszystkich dowolnych wartości) variant (different expr for report) Przykład: variance (Quantity) ----- (op: 2563.244, 4774.5438230) wariancja (ilość dla wszystkich typów produktów) --------- (opcjonalnie: 2563.244, 4774.5438230) wariancja (ilość na dowolny typ produktu) ------- (op: 2563.244, 4774.5438230) wariancja (ilość w raporcie) ------ --------------- (op: 3,564.89125097) Zwraca wariancję populacji zbioru liczb po odrzuceniu wartości null w tym zbiorze. Składnia: variance-pop (odrębny expr auto) variance-pop (odmienny expr dla wszystkich innych expr) variance-pop (odrębny expr dla raportu) Przykład: variance-pop (Quantity) ------- (op: 2,562.6282905, Variance-pop (ilość dla wszystkich typów produktów) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop (Ilość na dowolny typ produktu) -------- (op : 2.562.6282905, 4,773.47663957) variance-pop (ilość raportu) ------ (op: 3,564.80846781) Wysłane przez Ramana Reddy CH w 22: 44Cognos Streszczenia Funkcje Aggregate: Zwraca obliczoną wartość przy użyciu odpowiedniej funkcji agregowania, w oparciu o rodzaj agregacji wyrażenia. Składnia: aggregate (expr auto) aggregate (expr dla wszystkich wszystkich expr) aggregate (expr for report) Count: Zwraca liczbę wybranych elementów danych, z wyjątkiem wartości NULL. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: liczenie (odrębne wyrażenie) liczenie (odrębne wyrażenie dla wszystkich dowolnych wartości) liczenie (odrębne wyrażenie dla raportu) Przykład: liczba (gosalesgoretailers. Products. Product name) - (op: 41, 15, 21) Count (Typ produktu dla wszystkie Product line) ------------ (op: 5, 4, 4) Count (typ produktu dla dowolnej linii produktów) ----------- (op: 5, 4, 4) Liczba (Typ produktu dla raportu) ------------------- (op .: 21 dla wszystkich) Maksymalnie: Zwraca maksymalną wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: maksymalny (odrębny expr auto) maksymalny (odrębny expr dla wszystkich wszystkich expr) maksimum (odrębny expr dla raportu) Przykład: maximum (Quantity) -------------------- ------------ (op: 962) maks. (Ilość dla wszystkich gosalesgoretailers. Products. Product type) (op: 344,4368230) Maximum (Ilość dla każdego gosalesgoretailers. Products. Product name) (op. : 44,78,8230.) Maximum (Ilość raportu) ------------------- (op: 1,646) Minimum: Zwraca minimalną wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: minimalny (odrębny expr auto) minimum (odrębny expr dla wszystkich wszystkich expr) minimum (odrębny expr dla raportu) Przykład: minimum (Ilość) -------------- (op: 43,330, 142,150 Minimalna ilość (dla każdego typu produktu) ---- (op: 6, 4, 4, 8230.) Minimalny (Ilość na dowolny typ produktu) 8211 (op: 6, 4, 4.) Minimalna ilość (w raporcie) ----------------- (op: 2) Moving-Average: Zwraca wartość, dodając wartości do poprzedniej w oparciu o numericexp. Składnia: średnia ruchoma (numericexpr. Numericexpr w filtrze wstępnym exp) średnica ruchoma (odrębny numericexpr. Numericexpr filtr wstępny). dla wyrażenia dla raportu auto Przykład: średnia ruchoma (ilość, 2) (op: ilość Średnia przemieszczeniowa 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Ruchome sumy: Zwraca wartość dodając wartości do poprzedniej na podstawie składowej liczbicexp Składnia: (liczba, 3) Wyjście: Ilość Średnia ruchoma 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 (łącznie z liczbą całkowitą) w liczbie całkowitej (numericexpr. numericexpr w filtrze wstępnym exp) Procent: Zwraca procent całkowitej wartości dla wybranych elementów danych. Używany tylko w relacyjnych źródłach danych Składnia: procentowy (liczbicexpr przy exp filtru) procentowy (różny licznik liczbicexpr) dla expr dla raportu auto Przykład: procent (ilość) - ( op: 16, 12, 10). Procent: Zwraca wartość, w skali stu, która wskazuje procent rozkładu, który jest równy lub niższy od wybranych danych przedmiotów. Składnia: percentyl (numericexpr na exp filtru wstępnego) percentyla (odrębny filtr numericexpr). dla wyrażenia dla raportu auto Przykład: percentile (Ilość) -------- (op: 100, 95, 90) Quantile: Zwraca rangę wartości dla określonego zakresu. Zwraca liczbę całkowitą reprezentującą dowolny zakres szeregu, np. 1 (najwyższy) do 100 (najniższy). Składnia: quantile (numericexpr, numericexpr at exp filter) quantile (odrębny numericexpr, filtr liczbicekspr). dla wyrażenia dla raportu auto Przykład: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Kwartyl: Zwraca rangę wartości reprezentowanej jako liczba całkowita od 1 (najwyższa) do 4 ), w stosunku do grupy wartości. Składnia: kwartyl (liczbaicexpr w filtrze wstępnym exp) kwartyl (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: kwartyiel (Ilość) ---------- (op: 1, 2, 3, 4) Zwraca wartość rangi wybranych elementów danych. Jeśli dwa lub więcej wierszy są powiązane, to występuje luka w kolejności rankingowej wartości (znanej również jako ranking olimpijski). Składnia: rank (expr sortorder na exp filtra wstępnego) rank (different expr sortorder prefilter). dla wyrażenia dla raportu auto Przykład: rank Ilość) ----------------- (op: 1, 2, 3, 4, 8230 ..) Zwraca średnią rzędu (w tym bieżący wiersz) dla zestawu wartości Składnia: średnia-średnia (liczbaicexpr w filtrze wstępnym) średnia bieżąca (odrębny filtr wstępny numericexpr). do wyliczenia dla raportu auto Przykład: przeciętna średnia ilość) ------------ (op: ilość Średnia ruchoma 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Liczba biegów: zwraca liczbę biegnącą w wierszu (w tym (bieżący wiersz) dla zbioru wartości Składnia: liczenie-uruchomienie (liczbaicexpr w expfilterze) liczenie uruchomione (oddzielny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: liczenie uruchomieniowe (ilość) ------- (op: 1, 2, 3, 8230) Zwraca bieżącą różnicę w wierszu, liczoną jako różnica między wartością dla bieżącego wiersza a poprzednim wierszem (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: Różnica (numericexpr w filtrze wstępnym exp) Różnica w uruchomieniu (odrębny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: różnica robocza (ilość) - (op: null, 146420, -249,544, 8230 ..) wiersz (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: running-maximum (numericex pr at expfilter) maksymalny (zróżnicowany filtr wstępny numericexpr). dla wartości exr dla raportu auto Przykład: maksimum uruchomienia (Ilość) --------- (op: 198676, 345096) Zwraca bieżące minimum według wiersza (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-minimum (liczbaicexpr at exp filter) running-minimum (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: running-minimum (Ilość) --------- (op: 198676, 198676, 95552,) Zwraca bieżącą liczbę wierszy (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-total (numericexpr at expfilter) działa w całości (odrębny filtr wstępny numericexpr). dla expr dla raportu auto Przykład: suma całkowita (ilość) ----------- (op: 198676, 5437728230.) Zwraca standardowe odchylenie wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: odchylenie standardowe (odrębne expr auto) odchylenie standardowe (odrębne wyraŜenie dla wszystkich innych wyraŜeń) odchylenie standardowe (róŜne wartości dla raportu) przykład: odchylenie standardowe (ilość) ------ (op: 50.628, 69.098 8230) odchylenie standardowe (ilość sztuk dla wszystkich typów produktów) -------- (op: 50.628, 69.098, 8230) odchylenie standardowe (ilość na dowolny typ produktu) ------ (op: 50.628, 69.098 8230) odchylenie standardowe (ilość raportu) -------------------- (op: 59.70671027) Raport: odchylenie standardowe Odchylenie standardowe pop: oblicza odchylenie standardowe populacji i zwraca pierwiastek kwadratowy wariancji populacji. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: odchylenie standardowe-pop (odrębne expr auto) odchylenie standardowe-pop (odrębne wyrażenie dla wszystkich innych wartości) odchylenie standardowe-pop (odrębne wyrażenie dla raportu) Przykład: odchylenie standardowe-pop (ilość) ---- (opcjonalnie: 50.62240898, 69.09035128) odchylenie standardowe (ilość sztuk dla wszystkich typów produktów) - (op: 50.62240898, 69.09035128) odchylenie standardowe (ilość na dowolny typ produktu) (op .: 50.62240898, 69.09035128) standard - deviation-pop (Ilość raportu) --- (op: 59.70601702,) Total: Zwraca całkowitą wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: całkowity (odrębny expr auto) całkowity (odrębny expr dla wszystkich wszystkich expr) suma (odrębny expr dla raportu) Przykład: total (Quantity) --------------- (op: 198,676, 345,096) Razem (Ilość na wszystkie Typ produktu) ------- (op .: 198,676, 345,096) Razem (Ilość w jakiejkolwiek Typ produktu) ----- (op: 198,676, 345,096) Razem (Ilość w raporcie) --------------- (op: 2215354) Report: Total Variance: Zwraca wariancję wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: variance (different expr auto) wariancja (odrębna wartość wyrażona dla wszystkich dowolnych wartości) variant (different expr for report) Przykład: variance (Quantity) ----- (op: 2563.244, 4774.5438230) wariancja (ilość dla wszystkich typów produktów) --------- (opcjonalnie: 2563.244, 4774.5438230) wariancja (ilość na dowolny typ produktu) ------- (op: 2563.244, 4774.5438230) wariancja (ilość w raporcie) ------ --------------- (op: 3,564.89125097) Zwraca wariancję populacji zbioru liczb po odrzuceniu wartości null w tym zbiorze. Składnia: variance-pop (odrębny expr auto) variance-pop (odmienny expr dla wszystkich innych expr) variance-pop (odrębny expr dla raportu) Przykład: variance-pop (Quantity) ------- (op: 2,562.6282905, Variance-pop (ilość dla wszystkich typów produktów) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop (Ilość na dowolny typ produktu) -------- (op : 2,562.6282905, 4,773.47663957) variance-pop (Ilość raportu) ------ (op: 3,564.80846781) średnia ruchoma (odrębny numericexpr. Numericexpr prefilter). dla wyrażenia dla raportu auto Przykład: średnia ruchoma (ilość, 2) (op: ilość średnia ruchoma 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Ruchome sumy: Zwraca wartość dodając wartości do poprzedniej na podstawie składowej liczbicexp: (liczba, 3) Wyjście: Ilość Średnia ruchoma 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 (łącznie z liczbą całkowitą) w liczbie całkowitej (numericexpr. numericexpr w filtrze wstępnym exp) Procent: Zwraca procent całkowitej wartości dla wybranych elementów danych. Używany tylko w relacyjnych źródłach danych Składnia: procentowy (liczbicexpr przy exp filtru) procentowy (różny licznik liczbicexpr) dla expr dla raportu auto Przykład: procent (ilość) - ( op: 16, 12, 10). Procent: Zwraca wartość, w skali stu, która wskazuje procent rozkładu, który jest równy lub niższy od wybranych danych przedmiotów. Składnia: percentyl (numericexpr na exp filtru wstępnego) percentyla (odrębny filtr numericexpr). dla wyrażenia dla raportu auto Przykład: percentile (Ilość) -------- (op: 100, 95, 90) Quantile: Zwraca rangę wartości dla określonego zakresu. Zwraca liczbę całkowitą reprezentującą dowolny zakres szeregu, np. 1 (najwyższy) do 100 (najniższy). Składnia: quantile (numericexpr, numericexpr at exp filter) quantile (odrębny numericexpr, filtr liczbicekspr). dla wyrażenia dla raportu auto Przykład: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Kwartyl: Zwraca rangę wartości reprezentowanej jako liczba całkowita od 1 (najwyższa) do 4 ), w stosunku do grupy wartości. Składnia: kwartyl (liczbaicexpr w filtrze wstępnym exp) kwartyl (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: kwartyiel (Ilość) ---------- (op: 1, 2, 3, 4) Zwraca wartość rangi wybranych elementów danych. Jeśli dwa lub więcej wierszy są powiązane, to występuje luka w kolejności rankingowej wartości (znanej również jako ranking olimpijski). Składnia: rank (expr sortorder na exp filtra wstępnego) rank (different expr sortorder prefilter). dla wyrażenia dla raportu auto Przykład: rank Ilość) ----------------- (op: 1, 2, 3, 4, 8230 ..) Zwraca średnią rzędu (w tym bieżący wiersz) dla zestawu wartości Składnia: średnia-średnia (liczbaicexpr w filtrze wstępnym) średnia bieżąca (odrębny filtr wstępny numericexpr). do wyliczenia dla raportu auto Przykład: przeciętna średnia ilość) ------------ (op: ilość Średnia ruchoma 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Liczba biegów: zwraca liczbę biegnącą w wierszu (w tym (bieżący wiersz) dla zbioru wartości Składnia: liczenie-uruchomienie (numericexpr w filtrze wstępnym exp) liczenie uruchomione (oddzielny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: liczenie uruchomieniowe (ilość) ------- (op: 1, 2, 3, 8230) Zwraca bieżącą różnicę w wierszu, liczoną jako różnica między wartością dla bieżącego wiersza a poprzednim wierszem (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: Różnica (numericexpr w filtrze wstępnym exp) Różnica w uruchomieniu (odrębny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: różnica robocza (ilość) - (op: null, 146420, -249,544, 8230 ..) wiersz (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: running-maximum (numericex pr at expfilter) maksymalny (zróżnicowany filtr wstępny numericexpr). dla wartości exr dla raportu auto Przykład: maksimum uruchomienia (Ilość) --------- (op: 198676, 345096) Zwraca bieżące minimum według wiersza (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-minimum (liczbaicexpr w filtrze exp) running-minimum (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: running-minimum (Ilość) --------- (op: 198676, 198676, 95552,) Zwraca bieżącą liczbę wierszy (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-total (numericexpr at expfilter) działa w całości (odrębny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: suma całkowita (ilość) ----------- (op: 198676, 5437728230.) Zwraca standardowe odchylenie wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: odchylenie standardowe (odrębne expr auto) odchylenie standardowe (odrębne wyraŜenie dla wszystkich innych wyraŜeń) odchylenie standardowe (róŜne wartości dla raportu) przykład: odchylenie standardowe (ilość) ------ (op: 50.628, 69.098 8230) odchylenie standardowe (ilość sztuk dla wszystkich typów produktów) -------- (op: 50.628, 69.098, 8230) odchylenie standardowe (ilość na dowolny typ produktu) ------ (op: 50.628, 69.098 8230) odchylenie standardowe (ilość raportu) -------------------- (op: 59.70671027) Raport: odchylenie standardowe Odchylenie standardowe pop: oblicza odchylenie standardowe populacji i zwraca pierwiastek kwadratowy wariancji populacji. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: odchylenie standardowe-pop (odrębne expr auto) odchylenie standardowe-pop (odrębne wyrażenie dla wszystkich innych wartości) odchylenie standardowe-pop (odrębne wyrażenie dla raportu) Przykład: odchylenie standardowe-pop (ilość) ---- (opcjonalnie: 50.62240898, 69.09035128) odchylenie standardowe (ilość sztuk dla wszystkich typów produktów) - (op: 50.62240898, 69.09035128) odchylenie standardowe (ilość na dowolny typ produktu) (op .: 50.62240898, 69.09035128) standard - deviation-pop (Ilość raportu) --- (op: 59.70601702,) Total: Zwraca całkowitą wartość wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: całkowity (odrębny expr auto) całkowity (odrębny expr dla wszystkich wszystkich expr) całkowity (odrębny expr dla raportu) Przykład: total (Quantity) --------------- (op: 198,676, 345,096) Razem (Ilość na wszystkie Typ produktu) ------- (op .: 198,676, 345,096) Razem (Ilość w jakiejkolwiek Typ produktu) ----- (op: 198,676, 345,096) Razem (Ilość w raporcie) --------------- (op: 2215354) Report: Total Variance: Zwraca wariancję wybranych elementów danych. Odrębne słowo kluczowe jest dostępne dla wstecznej zgodności wyrażeń używanych w poprzednich wersjach produktu. Składnia: variance (different expr auto) wariancja (odrębna wartość wyrażona dla wszystkich dowolnych wartości) variant (different expr for report) Przykład: variance (Quantity) ----- (op: 2563.244, 4774.5438230) wariancja (ilość dla wszystkich typów produktów) --------- (opcjonalnie: 2563.244, 4774.5438230) wariancja (ilość na dowolny typ produktu) ------- (op: 2563.244, 4774.5438230) wariancja (ilość w raporcie) ------ --------------- (op: 3,564.89125097) Zwraca wariancję populacji zbioru liczb po odrzuceniu wartości null w tym zbiorze. Składnia: variance-pop (odrębny expr auto) variance-pop (odmienny expr dla wszystkich innych expr) variance-pop (odrębny expr dla raportu) Przykład: variance-pop (Quantity) ------- (op: 2,562.6282905, Variance-pop (ilość dla wszystkich typów produktów) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop (Ilość na dowolny typ produktu) -------- (op (Liczba, 2) (op: ilość Średnia wartość przeciętnej 198.676 198.676 345 096 271 886 95 542) wariera-pop (ilość raportu) ------ (op: 3,564.80846781) dla expr dla raportu auto Przykład: średnia ruchoma 220,324 96,246 95,889 Moving-Total Zwraca wartość poprzez dodanie wartości do poprzedniej na podstawie składowej liczbicexp Składnia: ruch-całkowita (numericexpr. Numericexpr na filtrze wstępnym exp) filtru wstępnego filtru liczbicexpr. auto Przykład: ruchome ogółem (Ilość, 3) Wyjście: Ilość Średni ruchoma 198,676 198,676 345,096 543,772 95,552 639,324 96 , 246 536 894 Procent: Zwraca procent całkowitej wartości dla wybranych elementów danych. Używany tylko w relacyjnych źródłach danych. Składnia: procent (liczbicexpr przy exp filtru wstępnego) procent (oddzielny filtr numericexpr). dla wartości procentowej dla raportu auto Przykład: procent (ilość) - (op: 16, 12, 10.) Procent: Zwraca wartość, w skali stu, co wskazuje procent rozkładu, który jest równy lub niższy od wybranego danych. Składnia: percentyl (numericexpr na exp filtru wstępnego) percentyla (odrębny filtr numericexpr). dla wyrażenia dla raportu auto Przykład: percentile (Ilość) -------- (op: 100, 95, 90) Quantile: Zwraca rangę wartości dla określonego zakresu. Zwraca liczbę całkowitą reprezentującą dowolny zakres szeregu, np. 1 (najwyższy) do 100 (najniższy). Składnia: quantile (numericexpr, numericexpr at exp filter) quantile (odrębny numericexpr, filtr liczbicekspr). dla wyrażenia dla raportu auto Przykład: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Kwartyl: Zwraca rangę wartości reprezentowanej jako liczba całkowita od 1 (najwyższa) do 4 ), w stosunku do grupy wartości. Składnia: kwartyl (liczbaicexpr w filtrze wstępnym exp) kwartyl (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: kwartyiel (Ilość) ---------- (op: 1, 2, 3, 4) Zwraca wartość rangi wybranych elementów danych. Jeśli dwa lub więcej wierszy są powiązane, to występuje luka w kolejności rankingowej wartości (znanej również jako ranking olimpijski). Składnia: rank (expr sortorder na exp filtra wstępnego) rank (different expr sortorder prefilter). dla wyrażenia dla raportu auto Przykład: rank Ilość) ----------------- (op: 1, 2, 3, 4, 8230 ..) Zwraca średnią rzędu (w tym bieżący wiersz) dla zestawu wartości Składnia: średnia-średnia (liczbaicexpr w filtrze wstępnym) średnia bieżąca (odrębny filtr wstępny numericexpr). do wyliczenia dla raportu auto Przykład: przeciętna średnia ilość) ------------ (op: ilość Średnia ruchoma 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Liczba biegów: zwraca liczbę biegnącą w wierszu (w tym (bieżący wiersz) dla zbioru wartości Składnia: liczenie-uruchomienie (numericexpr w filtrze wstępnym exp) liczenie uruchomione (oddzielny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: liczenie uruchomieniowe (ilość) ------- (op: 1, 2, 3, 8230) Zwraca bieżącą różnicę w wierszu, liczoną jako różnica między wartością dla bieżącego wiersza a poprzednim wierszem (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: Różnica (numericexpr w filtrze wstępnym exp) Różnica w uruchomieniu (odrębny filtr wstępny numericexpr) dla expr dla raportu auto Przykład: różnica robocza (ilość) - (op: null, 146420, -249,544, 8230 ..) wiersz (łącznie z bieżącym wierszem) dla zbioru wartości Składnia: running-maximum (numericex pr at expfilter) maksymalny (zróżnicowany filtr wstępny numericexpr). dla wartości exr dla raportu auto Przykład: maksimum uruchomienia (Ilość) --------- (op: 198676, 345096) Zwraca bieżące minimum według wiersza (łącznie z bieżącym wierszem) dla zbioru wartości. Składnia: running-minimum (liczbaicexpr w filtrze exp) running-minimum (oddzielny filtr wstępny numericexpr). dla wyrażenia dla raportu auto Przykład: running-minimum (Ilość) --------- (op: 198676, 198676, 95552,) Zwraca bieżącą liczbę wierszy (łącznie z bieżącym wierszem) dla zbioru wartości. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) moving-total ( distinct numericexpr. numericexpr prefilter ) . for expr for report auto Example: moving-total(Quantity,3) Output:Quantity Moving average 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Percentage: Returns the percent of the total value for selected data items. Only used in relational Data sources. Syntax: percentage ( numericexpr at exp prefilter ) percentage ( distinct numericexpr prefilter ) . for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: moving-total(Quantity,3) Output:Quantity Moving average 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Percentage: Returns the percent of the total value for selected data items. Only used in relational Data sources. Syntax: percentage ( numericexpr at exp prefilter ) percentage ( distinct numericexpr prefilter ) . for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) percentage ( distinct numericexpr prefilter ) . for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: percentage (Quantity) - (op: 16, 12, 10 . ) Report: Percentage. Percentile: Returns a value, on a scale of one hundred, that indicates the percent of a distribution that is equal to or below the selected data items. Syntax: percentile ( numericexpr at exp prefilter ) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) percentile ( distinct numericexpr prefilter ) . for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: percentile (Quantity) -------- (op: 100, 95, 90) Quantile: Returns the rank of a value for a range that you specify. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). Syntax: quantile ( numericexpr, numericexpr at exp prefilter ) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) quantile ( distinct numericexpr, numericexpr prefilter ) . for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: quantile (Quantity, 5) --- (op: 1, 2, 3, 4, 5) Quartile: Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. Syntax: quartile ( numericexpr at exp prefilter ) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) quartile ( distinct numericexpr prefilter ) . for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: quartile (Quantity) ---------- (op: 1, 2, 3, 4) Rank: Returns the rank value of selected data items. If two or more rows tie, then there is a gap in the sequence of ranked values (also known as Olympic ranking). Syntax: rank ( expr sortorder at exp prefilter ) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) rank ( distinct expr sortorder prefilter ) . for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: rank Quantity) ----------------- ( op: 1, 2, 3, 4, 8230..) Running-Average: Returns the running average by row (including the current row) for a set of values Syntax: running-average ( numericexpr at exp prefilter ) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-average ( distinct numericexpr prefilter ) . for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericex pr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-average Quantity) ------------ (op: Quantity Moving average 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Running-Count: Returns the running count by row (including the current row) for a set of values. Syntax: running-count ( numericexpr at exp prefilter ) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the differenc e between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-count ( distinct numericexpr prefilter ) . for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-count(Quantity) ------- (op: 1, 2, 3, 8230 ) Running-Difference: Returns a running difference by row, calculated as the difference between the value for the current row and the preceding row, (including the current row) for a set of values. Syntax: running-difference ( numericexpr at exp prefilter ) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-difference ( distinct numericexpr prefilter ) . for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-difference (Quantity) --(op: null, 146420, -249,544, 8230..) Running-Maximum: Returns the running maximum by row (including the current row) for a set of values. Syntax: running-maximum ( numericexpr at exp prefilter ) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-maximum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-maximum (Quantity) --------- (op: 198676, 345096) Report: Running Running-Minimum: Returns the running minimum by row (including the current row) for a set of values. Syntax: running-minimum ( numericexpr at exp prefilter ) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-minimum ( distinct numericexpr prefilter ) . for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-minimum (Quantity) --------- (op: 198676, 198676, 95552, ) Running-Total: Returns a running total by row (including the current row) for a set of values. Syntax: running-total ( numericexpr at exp prefilter ) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) running-total ( distinct numericexpr prefilter ) . for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total : Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance : Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781) for expr for report auto Example: running-total (Quantity) ----------- (op: 198676, 5437728230.) Standard-Deviation: Returns the standard deviation of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation ( distinct expr auto ) standard-deviation ( distinct expr for all any expr ) standard-deviation ( distinct expr for report ) Example: standard-deviation (Quantity) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for all Product type) -------- (op: 50.628, 69.098, 8230) standard-deviation (Quantity for any Product type) ------ (op: 50.628, 69.098 8230) standard-deviation (Quantity for report) -------------------- (op: 59.70671027) Report: Standard deviation Standard-Deviation pop: Computes the population standard deviation and returns the square root of the population variance. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: standard-deviation-pop ( distinct expr auto ) standard-deviation-pop ( distinct expr for all any expr ) standard-deviation-pop ( distinct expr for report ) Example: standard-deviation-pop (Quantity) ------- (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for all Product type) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for any Product type) (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantity for report) --- (op: 59.70601702, ) Total . Returns the total value of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: total ( distinct expr auto ) total ( distinct expr for all any expr ) total ( distinct expr for report ) Example: total (Quantity) --------------- (op: 198,676, 345,096) Total (Quantity for all Product type) ------- (op: 198,676, 345,096) Total (Quantity for any Product type) ----- (op: 198,676, 345,096) Total (Quantity for report) --------------- (op: 2215354) Report: Total Variance . Returns the variance of selected data items. The keyword distinct is available for backward compatibility of expressions used in previous versions of the product. Syntax: variance ( distinct expr auto ) variance ( distinct expr for all any expr ) variance ( distinct expr for report ) Example: variance (Quantity) ----- (op: 2563.244, 4774.5438230) variance(Quantity for all Product type) -------- (op: 2563.244, 4774.5438230) variance(Quantity for any Product type) ------- (op: 2563.244, 4774.5438230) variance(Quantity for report) ---------------------- (op: 3,564.89125097) Variance-pop: Returns the population variance of a set of numbers after discarding the nulls in this set. Syntax: variance-pop ( distinct expr auto ) variance-pop ( distinct expr for all any expr ) variance-pop ( distinct expr for report ) Example: variance-pop(Quantity) ------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for all Product type) ----------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for any Product type) -------- (op: 2,562.6282905, 4,773.47663957) variance-pop(Quantity for report) ------ (op: 3,564.80846781)Pinned topic Moving-total moving-average functions giving weird numbers Unanswered question This question has not been answered yet. Darren Gruber said: I have a fairly simple crosstab report that calculates a simple count of criteria intersection by month and year. (see screenshot). The count is working just fine, but the moving-total(count ,3)is producing some strange numbers. Heres how the help file describes the moving-total function. lttable border1gtlttbodygtlttrgtlttdgt lttdgtlttdgt lttdgtlttrgtlttbodygtlttablegt But as you can see in my attached screenshot, its not even waiting until it has 3 months of before it gives a result, which is also wrong. Also notice that if count is empty, the moving-total is empty even though it may have previous count rows to work with. Ive tried replacing moving-total with moving-average and I get similar results, albeit smaller numbers. Any help would be greatly appreciated. I can be more specific about the report if more information is needed. Updated on 2017-01-19T07:58:22Z at 2017-01-19T07:58:22Z by SystemAdmin Anyone willing to share their thoughts please do so. Thanks The results in your screenshot look correct. In Grp 1 you have the values January February March April May 198 177 158.5 0 0 The moving-totals are: January: (January value) (no preceding values) 198 0 198 February: (February value) (January value) (no preceding values) 177 198 0 375 March: (March value) (February value) (January value) 158.5 177 198 533.5 April: (April value) (March value) (February value) 0 158.5 177 335.5 May: (May value) (April value) (March value) 0 0 158.5 158.5 So the moving-total appears to be doing exactly what it should be doing. If you want to stop using the moving-total when the measure becomes zero then you might consider using additional logic in your expression. You might consider: On a side note, if you are using a dimensional package then it would be better to use member summaries instead of the regular summary functions intended for relational queries. The expression for the moving total with member summaries would look like: Updated on 2017-03-25T08:36:22Z at 2017-03-25T08:36:22Z by iron-man The results in your screenshot look correct. In Grp 1 you have the values January February March April May 198 177 158.5 0 0 The moving-totals are: January: (January value) (no preceding values) 198 0 198 February: (February value) (January value) (no preceding values) 177 198 0 375 March: (March value) (February value) (January value) 158.5 177 198 533.5 April: (April value) (March value) (February value) 0 158.5 177 335.5 May: (May value) (April value) (March value) 0 0 158.5 158.5 So the moving-total appears to be doing exactly what it should be doing. If you want to stop using the moving-total when the measure becomes zero then you might consider using additional logic in your expression. You might consider: ltpre classjava dw data-editor-langjava data-pbcklangjava dirltrgtIF (Total Headcount 0) THEN (0) ELSE (moving-total(Total Headcount, 3 for Year, Group)) ltpregt On a side note, if you are using a dimensional package then it would be better to use member summaries instead of the regular summary functions intended for relational queries. The expression for the moving total with member summaries would look like: ltpre classjava dw data-editor-langjava data-pbcklangjava dirltrgtaggregate(Total Headcount within set lastPeriods(3,currentMember(Cube. Time Dimension. Time Hierarchy)))) ltpregt Appreciate the inputs. I will give this a try. Thanks Phil WGood morningafternoon TM1 gurus, Im currently working on a sales project that requires a moving average rule. Dimensions are quotcustomerquot. quotLocationquot. quotMeasuresquot. quotYearquot such as 2017,2017,2017 and quotdayquot with the 365 days of the year that rolls up to the corresponding month as parent (Jul, Aug, Sep. ) and the month to the top parent quotTotal Yearquot (see example below) Im trying to show the sales daily average value based on a 10 day moving period, for example see below This means that May-15 shows the avrg of the values from May-15 to May-02 and so on. So my question is: How do I work out the avrg backwards based on the previous 10 days that have a value against, if there is no value then exclude it. What I mean by a value is something in the cube cell even if its a zero. Any help, hints andor tips will be greatly appreciated. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2017 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia Not too sure if it can be done via rules as you are looking to skip days which is 0. I tried using TI process to do it and it is achievable. Create a view of all days at N element level and years and set quotSkip Zero Blank valuesquot. temp1 temp2 temp2 temp3 temp3 temp4 temp4 temp5 temp5 temp6 temp6 temp7 temp7 temp8 temp8 temp9 temp9 temp10 temp10 Value CELLPUTN((temp1 temp2 temp3 temp4 temp5 temp6 temp7 temp8 temp9 temp10)10, testing4,YearX, MonthX, Avrg JOB Val) I can think of 1 way to do it via rules but its not exactly pretty. Put an attribute against every day called quotprior dayquot and populate it with you know what. Create an extra measure called quotCheckquot or something like that. 91Check93N: If (91Intake Value93ltgt0,1,0) 91Avrg JOB Val93N: ( DB(Cube, dim1, dim2. Day, Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Day, Prior Day),Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Attrs(Day, Day, Prior Day),Prior Day),Intake Value). and so on 10 times ) Same as above but for the quotCheckquot measure. You could also do it via a dimix that may look cleaner in the rule but is dependent on elements not moving. Presuming that at least 1 of your 10 days will have a value you should probably cheat and just feed the whole measure. A nicer way to do it possibly would be taking the values out to an intermediate cube and using consols to do the averages and then bring them back in. LORR wrote: What I mean by a value is something in the cube cell even if its a zero. I presume that you mean that zero is a significant value but that there may be days for which there is no value. The accepted way to implement this in TM1 is to use UNDEFVALS (publib. boulder. ibminfocenterctm1v9r5m0index. jsptopic2Fcom. ibm. swg. im. cognos. tm1ref.9.5.2.doc2Ftm1refid7852undefvals. html ) in the rule. However be aware that once you put it in the rule it will have a permanent effect on the cube and taking it out will not reverse that effect. Furthermore I do not believe that it is possible any more (9.5.2 and above) in a rule to distinguish between a cell that has a zero in it and a cell with the special undefined value. I would be delighted to be proved wrong in this. In previous versions they used to compare greater than zero but not any more. All things considered if you are importing the data with TI it would probably be safer and more understandable to have an extra measure (e. g. quotHas Dataquot) that you populate with 1 for every sales value that you populate. Of course if the values are entered by users in the cube viewer or in Contributor you cannot do this. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2017 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia Looks like a good idea. but i would like to confirm about the rules. using the rules given wouldnt it mean May-14 (May-07 May-08 May-09 May-10 May-11 May-14 ) 6 May-05 0 May-06 0 May-07 187,989 May-08 203,375 May-09 236,468 May-10 106,078 May-11 426,669 may-12 0 May-13 0 May-14 296,722 declanr wrote: I can think of 1 way to do it via rules but its not exactly pretty. Put an attribute against every day called quotprior dayquot and populate it with you know what. Create an extra measure called quotCheckquot or something like that. 91Check93N: If (91Intake Value93ltgt0,1,0) 91Avrg JOB Val93N: ( DB(Cube, dim1, dim2. Day, Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Day, Prior Day),Intake Value) DB(Cube, dim1, dim2, Attrs(Day, Attrs(Day, Day, Prior Day),Prior Day),Intake Value). and so on 10 times ) Same as above but for the quotCheckquot measure. You could also do it via a dimix that may look cleaner in the rule but is dependent on elements not moving. Presuming that at least 1 of your 10 days will have a value you should probably cheat and just feed the whole measure. A nicer way to do it possibly would be taking the values out to an intermediate cube and using consols to do the averages and then bring them back in. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2017 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia using the rules define by declanr, I guess it is possbile if the year and the month date dimension is combine into one dimension and use attribute to define prior day according to the existance of the data but this will require alot of work to maintain the attribute as well. winsonlee Regular Participant Posts: 180 Joined: Thu Jul 01, 2017 3:06 am OLAP Product: Cognos Express Version: 9.5 Excel Version: 2007 Location: Melbourne, Australia that looks like a resonable solution that doesnt require much work to maintain it. but would like to further emphasize that using dimix, the sequence of element created in the dimension is important. eg if Jun is created subsequently all the days follow by Jul and all the days, therefore it will comes to a time where the prior period of Jul-01 will be Jul. So it is advisable to create all parent element first then only the days element so that all the days is in correct orders. winsonlee wrote: Looks like a good idea. but i would like to confirm about the rules. using the rules given wouldnt it mean May-14 (May-07 May-08 May-09 May-10 May-11 May-14 ) 6 ah yes I see I mis-read the question. I now take it as the OP always wants to average 10 days worth of data but it will only ever be the last 10 days that had values in them. If that is the case I would still have the quotPriorquot attribute but populate it by a rule (I say this is what I would do. in reality I would use a TI but if a rule was essential). The rule would be something like: Prior PeriodS: If ( DB(Cube, Dim1, Dim2, Dimnm(Day, Dimix(Day, Day)-1), AVG Job Val)ltgt0, Dimnm(Day, Dimix(Day, Day)-1) , If ( DB(Cube, Dim1, Dim2, Dimnm(Day, Dimix(Day, Day)-2), AVG Job Val)ltgt0, Dimnm(Day, Dimix(Day, Day)-2) , If ( DB(Cube, Dim1, Dim2, Dimnm(Day, Dimix(Day, Day)-3), AVG Job Val)ltgt0, Dimnm(Day, Dimix(Day, Day)-3) , . and so on and so forth as many times as you think would be necessary to encompass however many blanks are likely to be in a row. If the Dim1, Dim2 etc all require a different take on this you would possibly need to do it againt a custom control cube rather than the actual attributes cube. Like I say this is starting to look a very messy method and I would probably try to avoid it myself. but I think it would work. Of course if you did this the rule from my previous comment would just have a divide by 10 instead of the variable denominator.