locked
Aggregate Functions used only for Numeric Data Type RRS feed

  • Question

  • Hello,

    May I ask you Which two series aggregate functions are only available on numeric field data types?

    BR,

    Greta

    Tuesday, July 18, 2017 7:28 AM

Answers

All replies

  • Hi, can you please provide some more detail? What do you mean by "series" ? And why only two?

    For reference, the FetchXML Aggregates are:

    1. Count
    2. Count Column
    3. Sum
    4. Average
    5. Min
    6. Max

    Count is not related to any fields.

    Count Column can be run against any field type.

    Sum and Average can be run against field types Integer (whole number), Decimal, Float, and Money (currency).

    Min and Max can be run against the same numerical types as Sum & Average, plus DateTime.


    • Edited by Aron F Wednesday, July 19, 2017 1:12 PM
    Wednesday, July 19, 2017 1:11 PM
  • Hello Aron,

    Well i saw this question in one of the exams:

    NO.34 Which two series aggregate functions are only available on numeric field data types? Each
    correct answer presents part of the solution.
    A. Count: Non-empty
    B. Count: All
    C. Avg
    D. Max

    In this case, we should choose Avg and Max right?

    BR,

    Greta

    Wednesday, July 19, 2017 1:15 PM
  • Ahh, OK, yes. Avg and Max.
    • Marked as answer by GretaKhalil Wednesday, July 19, 2017 1:28 PM
    Wednesday, July 19, 2017 1:18 PM

  • Thank you for your feedback, may i ask another question or get your contact details I have a list of questions. Shall I create a question for each of them?




    Wednesday, July 19, 2017 1:30 PM
  • You're welcome. For everyone's benefit I would suggest adding each as a separate question....


    • Edited by Aron F Wednesday, July 19, 2017 1:48 PM
    Wednesday, July 19, 2017 1:47 PM
  • OK I will thank you, can you see all my threads?
    Wednesday, July 19, 2017 1:52 PM