Comment calculer la différence de déplacement dans Cognos 8 Problème (résumé) Ce document décrit comment calculer la différence de déplacement dans Report Studio lorsque aucune fonction de différence de mouvement n'est disponible. Résolution du problème Calculez la différence de déplacement en fonction de la fonction de déplacement total. Créer un rapport de tableau croisé vide Tracez et déposez la ligne de produits dans les lignes et le mois de commande dans les colonnes Glissez les revenus dans la requête pour créer un autre élément de données (nommez-le D1) et utilisez l'expression suivante: Créez un autre élément de données (nommez-le D2) et utilisez l'expression suivante: D1-Revenu Créez un autre élément de données (nommez-le en mouvement-diff) et utilisez l'expression suivante: Revenu-D2 Revenus et (S): Windows Date modifiée: 24 2008Tableau en rapport Déplacement-total des fonctions de la moyenne mobile donnant des résultats bizarres Numbers Question non-répondue Cette question n'a pas encore reçu de réponse. Darren Gruber a dit: J'ai un rapport de tableaux croisés assez simple qui calcule un simple dénombrement des critères d'intersection par mois et année. (Voir capture d'écran). Le compte fonctionne très bien, mais le total mobile (count, 3) produit des nombres étranges. Voici comment le fichier d'aide décrit la fonction de déplacement total. Lttable border1gtlttbodygtlttrgtlttdgt lttdgtlttdgt lttdgtlttrgtlttbodygtlttablegt Mais comme vous pouvez le voir dans ma capture d'écran ci-jointe, ce n'est pas attendre jusqu'à ce qu'il a 3 mois avant qu'il donne un résultat, ce qui est également faux. Notez également que si count est vide, le total de déplacement est vide, même s'il peut avoir des lignes de comptage précédentes pour lesquelles travailler. Ive a essayé de remplacer le mouvement-total avec la moyenne mobile et j'obtiens des résultats semblables, bien que des nombres plus petits. Toute aide serait très appréciée. Je peux être plus précis sur le rapport si plus d'informations sont nécessaires. Mise à jour le 2012-01-19T07: 58: 22Z à 2012-01-19T07: 58: 22Z par SystemAdmin Toute personne disposée à partager leurs pensées s'il vous plaît le faire. Merci Les résultats de votre capture d'écran sont corrects. Dans le Grp 1, vous avez les valeurs Janvier Février Mars Avril Mai 198 177 158,5 0 0 Les totaux mobiles sont: Janvier: (valeur de janvier) (pas de valeurs précédentes) 198 0 198 Février: (valeur de février) (valeur de janvier) Valeurs) 177 198 0 375 Mars: (valeur de mars) (valeur de février) (valeur de janvier) 158,5 177 198 533,5 avril: (valeur d'avril) (valeur de mars) (valeur de février) 0 158,5 177 335,5 mai: (valeur de mai) Valeur) (valeur de mars) 0 0 158,5 158,5 Ainsi, le total mobile semble faire exactement ce qu'il devrait faire. Si vous souhaitez arrêter d'utiliser le total mobile lorsque la mesure devient nulle, vous pouvez envisager d'utiliser une logique supplémentaire dans votre expression. Vous pourriez envisager: Sur une note de côté, si vous utilisez un paquetage dimensionnel, alors il serait préférable d'utiliser des résumés membres au lieu des fonctions récapitulatives régulières destinées aux requêtes relationnelles. L'expression pour le total mobile avec les résumés des membres ressemblerait à: Mise à jour le 2014-03-25T08: 36: 22Z à 2014-03-25T08: 36: 22Z par iron-man Les résultats dans votre capture d'écran semblent corrects. Dans le Grp 1, vous avez les valeurs Janvier Février Mars Avril Mai 198 177 158,5 0 0 Les totaux mobiles sont: Janvier: (valeur de janvier) (pas de valeurs précédentes) 198 0 198 Février: (valeur de février) (valeur de janvier) Valeurs) 177 198 0 375 Mars: (valeur de mars) (valeur de février) (valeur de janvier) 158,5 177 198 533,5 avril: (valeur d'avril) (valeur de mars) (valeur de février) 0 158,5 177 335,5 mai: (valeur de mai) Valeur) (valeur de mars) 0 0 158,5 158,5 Ainsi, le total mobile semble faire exactement ce qu'il devrait faire. Si vous souhaitez arrêter d'utiliser le total mobile lorsque la mesure devient nulle, vous pouvez envisager d'utiliser une logique supplémentaire dans votre expression. Vous pourriez envisager: ltpre classjava dw data-editor-langjava data-pbcklangjava dirltrgtIF (Effectif total 0) THEN (0) ELSE (total mobile, 3 pour l'année, le groupe)) ltpregt Sur une note latérale, si vous êtes À l'aide d'un paquetage dimensionnel, il serait préférable d'utiliser des résumés de membres au lieu des fonctions récapitulatives régulières destinées aux requêtes relationnelles. L'expression du total mobile avec les résumés des membres ressemblerait à: ltpre classjava dw données-éditeur-langjava data-pbcklangjava dirltrgtaggregate (Total d'effectifs dans le set lastPeriods (3, currentMember (Cube. Time Dimension. Time Hiérarchie))) ltpregt Apprécier le contributions. Je veux bien essayer. Merci Phil WCognos Résumés Fonctions Agrégat: retourne une valeur calculée à l'aide de la fonction d'agrégation appropriée, en fonction du type d'agrégation de l'expression. Syntaxe: aggregate (expr auto) aggregate (expr pour tous les expr) aggregate (expr for report) Count: Renvoie le nombre d'éléments de données sélectionnés, excluant les valeurs NULL. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: count (distinct expr auto) count (distinct expr pour tous les expr) count (distinct expr pour le rapport) Exemple: count (gosalesgoretailers. Products. Product name) - (op: 41, 15, 21) ------------ (op: 5, 4, 4) Count (Type de produit pour n'importe quelle ligne de produits) ----------- (op: 5, 4, 4) Count (Type de produit pour Report) ------------------- (op: 21 pour tous) Maximum: Renvoie la valeur maximale des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: maximum (distinct expr auto) maximum (distinct expr pour tout expr) maximum (distinct expr pour le rapport) Exemple: maximum (Quantité) -------------------- ------------ (op: 962) maximum (Quantité pour tous les gosalesgoretailers. Products. Product type) (op: 344,4368230) Maximum (Quantité pour tout gosalesgoretailers. Products. Product name) (op : 44,78,8230.) Maximum (Quantité pour rapport) ------------------- (op: 1,646) Minimum: Renvoie la valeur minimale des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe minimale (distincte expr auto) minimum (distinct expr pour tout expr) minimum (distinct expr pour rapport) Exemple: minimum (quantité) -------------- (op: 43,330, 142,150 Minimum (Quantité pour tout type de produit) 8211 (op: 6, 4, 4) Minimum (Quantité pour tout type de produit) ---- (op: 6, 4, ----------------- (op: 2) Moving-Average: Renvoie la valeur en ajoutant les valeurs à la précédente basée sur le nombre dexp. Syntaxe: moyenne mobile (numericexpr. Numericexpr au préfiltre d'exp) moyenne mobile (distinct numericexpr. Numericexpr prefilter). Pour expr pour l'auto de rapport Exemple: moyenne mobile (Quantité, 2) (op: Quantité Moyenne mobile 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Total mobile: Retourne la valeur en ajoutant les valeurs à la précédente basée sur la syntaxe numericexp: (Nombre, 3) Sortie: Quantité Moyenne mobile 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Nombre total de mouvements (nombre, 3) Nombre total de mouvements (nombre, Pour expr pour l'auto de rapport Exemple: pourcentage (Quantité) - (Pourcentage de la valeur totale pour les données sélectionnées. Op: 16, 12, 10.) Percentile: renvoie une valeur, sur une échelle de cent, qui indique le pourcentage d'une distribution qui est égale ou inférieure aux éléments de données sélectionnés. Syntaxe: percentile (numécixpr au préfiltre de l'exp) percentile (préfixe distinct du nombre numérique). Pour expr pour report auto Exemple: percentile (Quantité) -------- (op: 100, 95, 90) Quantile: Renvoie le rang d'une valeur pour une plage que vous spécifiez. Il renvoie des entiers pour représenter n'importe quelle rangée de rangs, tels que 1 (le plus haut) à 100 (le plus bas). Syntaxe: quantile (numericexpr, numericexpr au préfiltre d'exp) quantile (numericexpr distinct, prefixter de numericexpr). Quartile: renvoie le rang d'une valeur, représentée par des nombres entiers de 1 (le plus élevé) à 4 (le plus bas) ), Par rapport à un groupe de valeurs. Syntaxe: quartile (quartex) au quartile (préfixe numérique). Expr for report auto Exemple: quartile (Quantité) ---------- (op: 1, 2, 3, 4) Renvoie la valeur de rang des éléments de données sélectionnés. Si deux rangées ou plus se nouent, il ya un écart dans la séquence des valeurs classées (également connu sous le nom de classement olympique). Syntaxe: rang (expr sortorder au préfiltre d'exp) rang (distinct expr sortorder préfiltre). Pour expr pour report auto Exemple: rank Quantité) ----------------- (op: 1, 2, 3, 4, 8230 ..) Renvoie la moyenne courante par ligne (y compris La ligne courante) pour un ensemble de valeurs Syntaxe: run-average (numericexpr au préfiltre d'exp) average-running (prefixter numericexpr distinct). Pour expr pour l'auto de rapport Exemple: moyenne courante Quantité) ------------ (op: Quantité Moyenne mobile 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Comptage-exécution: Renvoie le nombre de commandes par ligne (y compris La ligne courante) pour un ensemble de valeurs Syntaxe: run-count (numericexpr au préfiltre d'exp) count-run (distinct numericexpr prefilter) pour expr pour report auto Exemple: running-count (Quantity) ------- (Op: 1, 2, 3, 8230) Retourne une différence de ligne par ligne, calculée comme la différence entre la valeur de la ligne courante et la ligne précédente (y compris la ligne courante) pour un ensemble de valeurs Syntaxe: Exemple: running-difference (Quantité) - (op: null, 146420, -249,544, 8230 ..) Renvoie le nombre maximal d'exécution par Syntaxe: running-maximum (numericexpr au préfiltre d'exp) running-maximum (prefilter numericexpr distinct). Expr for report auto Exemple: running-maximum (Quantité) --------- (op: 198676, 345096) Renvoie le minimum courant par ligne (y compris la ligne courante) pour un ensemble de valeurs. Syntaxe: running-minimum (numericexpr au préfiltre d'exp) running-minimum (distinct prefixter numericexpr). Expr for report auto Exemple: running-minimum (Quantité) --------- (op: 198676, 198676, 95552,) Renvoie un total courant par ligne (y compris la ligne courante) pour un ensemble de valeurs. Syntaxe: running-total (numericexpr au préfiltre d'exp) running-total (distinct prefixter de numericexpr). For expr for report auto Exemple: running-total (Quantité) ----------- (op: 198676, 5437728230.) Renvoie l'écart-type des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: écart-type (distinct expr auto) écart-type (expr distinct pour tout expr) écart-type (expr distinct pour le rapport) Exemple: écart-type ------ (op: 50.628, 69.098 8230) écart type (Quantité pour tout type de produit) -------- (op: 50.628, 69.098, 8230) écart-type (Quantité pour tout type de produit) ------ (op: 50.628, 69.098 8230) écart-type (Quantité pour rapport) -------------------- (op: 59.70671027) Rapport: Écart-type Standard-Écart-type: Calcule l'écart type de la population Et renvoie la racine carrée de la variance de population. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: écart-standard-pop (distinct expr auto) écart-standard-pop (expr distinct pour tout expr) écart-standard-pop (expr distinct pour le rapport) Exemple: (Pour tout type de produit) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantité pour tout type de produit) (op: 50.62240898, 69.09035128) standard - deviation-pop (Quantité pour rapport) --- (op: 59.70601702,) Total: Renvoie la valeur totale des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: total (distinct expr auto) total (distinct expr pour tout expr) total (distinct expr pour rapport) Exemple: total (Quantité) --------------- (op: 198,676, 345 096 Total (Quantité pour tout type de produit) ------- (op: 198,676, 345,096) Total (Quantité pour tout type de produit) ----- (op: 198,676, 345,096) --------------- (op: 2215354) Report: Total Variance: Renvoie la variance des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Exemple: variance (Quantité) ----- (op: 2563.244, 4774.5438230) variance (Quantité pour tout type de produit) Variance (expr distincte) ------- (op: 2563.244, 4774.5438230) variance (Quantité pour tout type de produit) ------- (op: 2563.244, 4774.5438230) --------------- (op: 3,564.89125097) Renvoie la variance de population d'un ensemble de nombres après avoir éliminé les valeurs nulles dans cet ensemble. Variance-pop (expr distincte) variance-pop (expr distincte pour tout expr) variance-pop (expr distincte pour le rapport) Exemple: variance-pop (Quantité) ------- (op: 2.562.6282905, (Quantité pour tout type de produit) ----------- (op: 2.562.6282905, 4,773.47663957) variance-pop (Quantité pour tout type de produit) -------- (op : 2.562.6282905, 4,773.47663957) variance-pop (Quantité pour rapport) ------ (op: 3,564.80846781) moyenne mobile (préfixe numérique numericexpr. Numericexpr). Pour expr pour l'auto de rapport Exemple: moyenne mobile (Quantité, 2) (op: Quantité Moyenne mobile 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Total mobile: Retourne la valeur en ajoutant les valeurs à la précédente basée sur la syntaxe numericexp: (Nombre, 3) Sortie: Quantité Moyenne mobile 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Nombre total de mouvements (nombre, 3) Nombre total de mouvements (nombre, Pour expr pour l'auto de rapport Exemple: pourcentage (Quantité) - (Pourcentage de la valeur totale pour les données sélectionnées. Op: 16, 12, 10.) Percentile: renvoie une valeur, sur une échelle de cent, qui indique le pourcentage d'une distribution qui est égale ou inférieure aux éléments de données sélectionnés. Syntaxe: percentile (numécixpr au préfiltre de l'exp) percentile (préfixe distinct du nombre numérique). Pour expr pour report auto Exemple: percentile (Quantité) -------- (op: 100, 95, 90) Quantile: Renvoie le rang d'une valeur pour une plage que vous spécifiez. Il renvoie des entiers pour représenter n'importe quelle rangée de rangs, tels que 1 (le plus haut) à 100 (le plus bas). Syntaxe: quantile (numericexpr, numericexpr au préfiltre d'exp) quantile (numericexpr distinct, prefixter de numericexpr). Quartile: renvoie le rang d'une valeur, représentée par des nombres entiers de 1 (le plus élevé) à 4 (le plus bas) ), Par rapport à un groupe de valeurs. Syntaxe: quartile (quartex) au quartile (préfixe numérique). Expr for report auto Exemple: quartile (Quantité) ---------- (op: 1, 2, 3, 4) Renvoie la valeur de rang des éléments de données sélectionnés. Si deux rangées ou plus se nouent, il ya un écart dans la séquence des valeurs classées (également connu sous le nom de classement olympique). Syntaxe: rang (expr sortorder au préfiltre d'exp) rang (distinct expr sortorder préfiltre). Pour expr pour report auto Exemple: rank Quantité) ----------------- (op: 1, 2, 3, 4, 8230 ..) Renvoie la moyenne courante par ligne (y compris La ligne courante) pour un ensemble de valeurs Syntaxe: run-average (numericexpr au préfiltre d'exp) average-running (prefixter numericexpr distinct). Pour expr pour l'auto de rapport Exemple: moyenne courante Quantité) ------------ (op: Quantité Moyenne mobile 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Comptage-exécution: Renvoie le nombre de commandes par ligne (y compris La ligne courante) pour un ensemble de valeurs Syntaxe: run-count (numericexpr au préfilm de l'exp) count-run (distinct prefixter du nombre) (Op: 1, 2, 3, 8230) Retourne une différence de ligne par ligne, calculée comme la différence entre la valeur de la ligne courante et la ligne précédente (y compris la ligne courante) pour un ensemble de valeurs Syntaxe: Exemple: running-difference (Quantité) - (op: null, 146420, -249,544, 8230 ..) Renvoie le nombre maximal d'exécution par Syntaxe: running-maximum (numericexpr au préfiltre d'exp) running-maximum (prefilter numericexpr distinct). Expr for report auto Exemple: running-maximum (Quantité) --------- (op: 198676, 345096) Renvoie le minimum courant par ligne (y compris la ligne courante) pour un ensemble de valeurs. Syntaxe: running-minimum (numericexpr au préfiltre d'exp) running-minimum (distinct prefixter numericexpr). Expr for report auto Exemple: running-minimum (Quantité) --------- (op: 198676, 198676, 95552,) Renvoie un total courant par ligne (y compris la ligne courante) pour un ensemble de valeurs. Syntaxe: running-total (numericexpr au préfiltre d'exp) running-total (distinct prefixter de numericexpr). For expr for report auto Exemple: running-total (Quantité) ----------- (op: 198676, 5437728230.) Renvoie l'écart-type des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: écart-type (distinct expr auto) écart-type (expr distinct pour tout expr) écart-type (expr distinct pour le rapport) Exemple: écart-type ------ (op: 50.628, 69.098 8230) écart type (Quantité pour tout type de produit) -------- (op: 50.628, 69.098, 8230) écart-type (Quantité pour tout type de produit) ------ (op: 50.628, 69.098 8230) écart-type (Quantité pour rapport) -------------------- (op: 59.70671027) Rapport: Écart-type Standard-Écart-type: Calcule l'écart type de la population Et renvoie la racine carrée de la variance de population. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: écart-standard-pop (distinct expr auto) écart-standard-pop (expr distinct pour tout expr) écart-standard-pop (expr distinct pour le rapport) Exemple: (Pour tout type de produit) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantité pour tout type de produit) (op: 50.62240898, 69.09035128) standard - deviation-pop (Quantité pour rapport) --- (op: 59.70601702,) Total: Renvoie la valeur totale des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: total (distinct expr auto) total (distinct expr pour tout expr) total (distinct expr pour rapport) Exemple: total (Quantité) --------------- (op: 198,676, 345 096 Total (Quantité pour tout type de produit) ------- (op: 198,676, 345,096) Total (Quantité pour tout type de produit) ----- (op: 198,676, 345,096) --------------- (op: 2215354) Report: Total Variance: Renvoie la variance des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Exemple: variance (Quantité) ----- (op: 2563.244, 4774.5438230) variance (Quantité pour tout type de produit) Variance (expr distincte) ------- (op: 2563.244, 4774.5438230) variance (Quantité pour tout type de produit) ------- (op: 2563.244, 4774.5438230) --------------- (op: 3,564.89125097) Renvoie la variance de population d'un ensemble de nombres après avoir éliminé les valeurs nulles dans cet ensemble. Variance-pop (expr distincte) variance-pop (expr distincte pour tout expr) variance-pop (expr distincte pour le rapport) Exemple: variance-pop (Quantité) ------- (op: 2.562.6282905, (Quantité pour tout type de produit) ----------- (op: 2.562.6282905, 4,773.47663957) variance-pop (Quantité pour tout type de produit) -------- (op : 2,562.6282905, 4,773.47663957) variance-pop (Quantité pour rapport) ------ (op: 3,564.80846781) pour expr pour rapport auto Exemple: moyenne mobile (Quantité, 2) (op: Quantité Moyenne mobile 198,676 198,676 345,096 271,886 95,552 220,324 96,246 95,889 Moving-Total Renvoie la valeur en ajoutant les valeurs à la précédente basée sur le nombre dexp Syntaxe: moving-total (numericexpr. Numericexpr à exp prefilter) move-total (distinct numericexpr. Auto Exemple: total mobile (Quantité, 3) Sortie: Quantité Moyenne mobile 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Pourcentage: Renvoie le pourcentage de la valeur totale des éléments de données sélectionnés. Utilisé uniquement dans les sources de données relationnelles. Syntaxe: pourcentage (numericexpr au préfiltre d'exp) pourcentage (préfixe du nombre numérique précisé). Pour expr pour l'auto de rapport Exemple: pourcentage (Quantité) - (op: 16, 12, 10.) Période: Renvoie une valeur, sur une échelle de cent, qui indique le pourcentage d'une distribution égale ou inférieure à la valeur sélectionnée Éléments de données. Syntaxe: percentile (numécixpr au préfiltre de l'exp) percentile (préfixe distinct du nombre numérique). Pour expr pour report auto Exemple: percentile (Quantité) -------- (op: 100, 95, 90) Quantile: Renvoie le rang d'une valeur pour une plage que vous spécifiez. Il renvoie des entiers pour représenter n'importe quelle rangée de rangs, tels que 1 (le plus haut) à 100 (le plus bas). Syntaxe: quantile (numericexpr, numericexpr au préfiltre d'exp) quantile (numericexpr distinct, prefixter de numericexpr). Quartile: renvoie le rang d'une valeur, représentée par des nombres entiers de 1 (le plus élevé) à 4 (le plus bas) ), Par rapport à un groupe de valeurs. Syntaxe: quartile (quartex) au quartile (préfixe numérique). Expr for report auto Exemple: quartile (Quantité) ---------- (op: 1, 2, 3, 4) Renvoie la valeur de rang des éléments de données sélectionnés. Si deux rangées ou plus se nouent, il ya un écart dans la séquence des valeurs classées (également connu sous le nom de classement olympique). Syntaxe: rang (expr sortorder au préfiltre d'exp) rang (distinct expr sortorder préfiltre). Pour expr pour report auto Exemple: rank Quantité) ----------------- (op: 1, 2, 3, 4, 8230 ..) Renvoie la moyenne courante par ligne (y compris La ligne courante) pour un ensemble de valeurs Syntaxe: run-average (numericexpr au préfiltre d'exp) average-running (prefixter numericexpr distinct). Pour expr pour l'auto de rapport Exemple: moyenne courante Quantité) ------------ (op: Quantité Moyenne mobile 198,676 198,676 345,096 271,886 95,552 213,108 96,246 183,892 Comptage-exécution: Renvoie le nombre de commandes par ligne (y compris La ligne courante) pour un ensemble de valeurs Syntaxe: run-count (numericexpr au préfilm de l'exp) count-run (distinct prefixter du nombre) (Op: 1, 2, 3, 8230) Retourne une différence de ligne par ligne, calculée comme la différence entre la valeur de la ligne courante et la ligne précédente (y compris la ligne courante) pour un ensemble de valeurs Syntaxe: Exemple: running-difference (Quantité) - (op: null, 146420, -249,544, 8230 ..) Renvoie le nombre maximal d'exécution par Syntaxe: running-maximum (numericexpr au préfiltre d'exp) running-maximum (prefilter numericexpr distinct). Expr for report auto Exemple: running-maximum (Quantité) --------- (op: 198676, 345096) Renvoie le minimum courant par ligne (y compris la ligne courante) pour un ensemble de valeurs. Syntaxe: running-minimum (numericexpr au préfiltre d'exp) running-minimum (distinct prefixter numericexpr). Expr for report auto Exemple: running-minimum (Quantité) --------- (op: 198676, 198676, 95552,) Renvoie un total courant par ligne (y compris la ligne courante) pour un ensemble de valeurs. Syntaxe: running-total (numericexpr au préfiltre d'exp) running-total (distinct prefixter de numericexpr). For expr for report auto Exemple: running-total (Quantité) ----------- (op: 198676, 5437728230.) Renvoie l'écart-type des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: écart-type (distinct expr auto) écart-type (expr distinct pour tout expr) écart-type (expr distinct pour le rapport) Exemple: écart-type ------ (op: 50.628, 69.098 8230) écart type (Quantité pour tout type de produit) -------- (op: 50.628, 69.098, 8230) écart-type (Quantité pour tout type de produit) ------ (op: 50.628, 69.098 8230) écart-type (Quantité pour rapport) -------------------- (op: 59.70671027) Rapport: Écart-type Standard-Écart-type: Calcule l'écart type de la population Et renvoie la racine carrée de la variance de population. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: écart-standard-pop (distinct expr auto) écart-standard-pop (expr distinct pour tout expr) écart-standard-pop (expr distinct pour le rapport) Exemple: (Pour tout type de produit) - (op: 50.62240898, 69.09035128) standard-deviation-pop (Quantité pour tout type de produit) (op: 50.62240898, 69.09035128) standard - deviation-pop (Quantité pour rapport) --- (op: 59.70601702,) Total: Renvoie la valeur totale des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Syntaxe: total (distinct expr auto) total (distinct expr pour tout expr) total (distinct expr pour rapport) Exemple: total (Quantité) --------------- (op: 198,676, 345 096 Total (Quantité pour tout type de produit) ------- (op: 198,676, 345,096) Total (Quantité pour tout type de produit) ----- (op: 198,676, 345,096) --------------- (op: 2215354) Report: Total Variance: Renvoie la variance des éléments de données sélectionnés. Le mot clé distinct est disponible pour la compatibilité descendante des expressions utilisées dans les versions précédentes du produit. Exemple: variance (Quantité) ----- (op: 2563.244, 4774.5438230) variance (Quantité pour tout type de produit) Variance (expr distincte) ------- (op: 2563.244, 4774.5438230) variance (Quantité pour tout type de produit) ------- (op: 2563.244, 4774.5438230) --------------- (op: 3,564.89125097) Renvoie la variance de population d'un ensemble de nombres après avoir éliminé les valeurs nulles dans cet ensemble. Variance-pop (expr distincte) variance-pop (expr distincte pour tout expr) variance-pop (expr distincte pour le rapport) Exemple: variance-pop (Quantité) ------- (op: 2.562.6282905, (Quantité pour tout type de produit) ----------- (op: 2.562.6282905, 4,773.47663957) variance-pop (Quantité pour tout type de produit) -------- (op : 2.562.6282905, 4,773.47663957) variance-pop (quantité pour le rapport) ------ (op: 3,564.80846781) total mobile (distinctes numericexpr numericexpr préfiltre). Pour expr pour le rapport auto Exemple: total mobile (Quantité, 3) Sortie: Quantité Moyenne mobile 198,676 198,676 345,096 543,772 95,552 639,324 96,246 536,894 Pourcentage: Renvoie le pourcentage de la valeur totale des éléments de données sélectionnés. Utilisé uniquement dans les sources de données relationnelles. Syntaxe: pourcentage (numericexpr au préfiltre d'exp) pourcentage (préfixe du nombre numérique précisé). Pour expr pour l'auto de rapport Exemple: pourcentage (Quantité) - (op: 16, 12, 10.) Période: Renvoie une valeur, sur une échelle de cent, qui indique le pourcentage d'une distribution égale ou inférieure à la valeur sélectionnée Éléments de données. Syntaxe: percentile (numécixpr au préfiltre de l'exp) percentile (préfixe distinct du nombre numérique). Pour expr pour report auto Exemple: percentile (Quantité) -------- (op: 100, 95, 90) Quantile: Renvoie le rang d'une valeur pour une plage que vous spécifiez. Il renvoie des entiers pour représenter n'importe quelle rangée de rangs, tels que 1 (le plus haut) à 100 (le plus bas). Syntaxe: quantile (numericexpr, numericexpr au préfiltre d'exp) quantile (numericexpr distinct, prefixter de numericexpr). Quartile: renvoie le rang d'une valeur, représentée par des nombres entiers de 1 (le plus élevé) à 4 (le plus bas) ), Par rapport à un groupe de valeurs. Syntaxe: quartile (quartex) au quartile (préfixe numérique). Expr for report auto Exemple: quartile (Quantité) ---------- (op: 1, 2, 3, 4) Renvoie la valeur de rang des éléments de données sélectionnés. Si deux rangées ou plus se nouent, il ya un écart dans la séquence des valeurs classées (également connu sous le nom de classement olympique). 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 ( 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: 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 ( 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) 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 ( 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: 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 ( 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) 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 ( 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: 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 ( 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) 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 ( 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: 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 ( 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) 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 ( 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: 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 ( 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) 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 ( 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: 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 ( 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-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 ( 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-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 ( 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)
No comments:
Post a Comment