Calculations and aggregations

398 questions in this forum

1. How to get the max value for multiple fields?

   Asked by SunakoChan, February 12, 2022

   0 votes
   1 answer
2. Averages

   Asked by ptauk1, April 17, 2012

   0 votes
   6 answers
3. Referencing data for Calculation

   Asked by AIloser, November 10, 2021

   0 votes
   4 answers
4. How to create a Formula based on another formula

   Asked by Woolf, October 13, 2021

   • formula
   • current date
   • nesting
   0 votes
   5 answers
5. Blank value result

   Asked by Kuroshi, January 31, 2021

   0 votes
   4 answers
6. Concatenate Date and Time Fields

   Asked by Role21, October 23, 2018

   0 votes
   4 answers
7. Get the duration using a Calculated Field

   Asked by astroboy, March 17, 2020

   0 votes
   2 answers
8. Remove vowels from the string

   Asked by Kuroshi, July 25, 2021

   0 votes
   2 answers
9. error Syntax error with using DateDiff in calculated field in table

   Asked by SGProject, October 22, 2016

   • syntax
   • datediff
   • calcultated field
   • table
   • formula
   0 votes
   5 answers
10. Error in formula

    Asked by Kuroshi, November 30, 2019

    0 votes
    4 answers
11. Calculate DataPage text fields

    Asked by gmwvine, May 22, 2013

    0 votes
    3 answers
12. Concatenate In The Calculated Field

    Asked by Elena, June 10, 2014

    0 votes
    6 answers
13. Error in Formula

    Asked by Kuroshi, December 26, 2019

    0 votes
    2 answers
14. Formatting Average in Aggregate Field

    Asked by Woolf, January 13, 2022

    0 votes
    4 answers
15. Concatenate two fields

    Asked by vigreen, January 12, 2022

    0 votes
    1 answer
16. Hide Calculated Fields

    Asked by Role21, December 23, 2018

    0 votes
    5 answers
17. Text and numeric values in calculation

    Asked by Sam23, December 27, 2021

    0 votes
    6 answers
18. Error converting data type varchar to float

    Asked by imJihyo, October 24, 2021

    0 votes
    2 answers
19. Aggregation calculation for Standard deviation over a time period ex weekly)

    Asked by Sergioleno1, December 15, 2021

    0 votes
    1 answer
20. Counting a field match and sorting by another field value - simple but elusive to me

    Asked by roattw, December 10, 2021

    0 votes
    2 answers
21. Only showing result once

    Asked by NikkiC, March 23, 2018

    • calculated field
    • tabular report
    0 votes
    6 answers
22. Sql Statement To List Only Distinct Records In Calculated Fields

    Asked by cpcbsa, September 8, 2014

    • SQL
    • REPORT
    • CALCULATED
    0 votes
    2 answers
23. Trigger Action Insert Select Distinct: Multiple Values

    Asked by vanderLeest, December 14, 2017

    • trigger action insert select distinct: multiple values
    • trigger action
    • insert
    • select distinct
    0 votes
    5 answers
24. Formula to get value in a table

    Asked by taylorswiftlover, February 28, 2019

    0 votes
    8 answers
25. Unable to Group By calculated field

    Asked by al3sha, March 7, 2021

    0 votes
    2 answers