Calculations and aggregations

127 questions in this forum

1. Date Calculation in a submission form

   Asked by NeoInJS, February 15

   • date
   • calculated fields
   • script
   0 votes
   3 answers
2. Auto calculating and submitting a form

   Asked by GingerDan, October 8

   • datapage
   • editrecord
   • javascript
   • htmlblock
   • sql
   0 votes
   1 answer
3. SumIf Formulas

   Asked by shaferam, October 5

   0 votes
   3 answers
4. Concatenate column values as string in calculated field

   Asked by Heineperson, September 12

   • concatenate
   • sql
   • calculated field
   • tabular report
   0 votes
   2 answers
5. Calculate on report details page

   Asked by mdav20, September 13

   0 votes
   1 answer
6. Sum of hrs using a virtual field?

   Asked by mdav20, September 8

   0 votes
   0 answers
7. Hiding columns including aggregation rows in Datapage

   Asked by ray985, August 9

   0 votes
   1 answer
8. Finding Maximum Date

   Asked by jsgarlata, August 9

   • dates
   0 votes
   2 answers
9. Conditional statement in formula

   Asked by JEllington, August 17

   • formula
   • conditional
   0 votes
   1 answer
10. Sum Payment Due based on search criteria

    Asked by Breee, August 1

    • calculation
    • sum
    • date criteria
    • date range
    • sql
    • aggregations
    • dynamic totals
    0 votes
    1 answer
11. Median Calculation

    Asked by Elena, March 26, 2016

    • Median
    • Statistical Calculations
    0 votes
    1 answer
12. Fiscal year in Formula field

    Asked by NeoInJS, August 2

    • formula field
    • fiscal year
    0 votes
    2 answers
13. Use a Formula within a Formula

    Asked by tconnery, July 26

    • formula
    • calculation
    0 votes
    2 answers
14. SQL Select SUM and Group BY Statements for Aggregations in Calculated field

    Asked by Breee, July 20

    • sql
    • calculated field
    • aggregations
    • group by
    • sql select
    • sum
    0 votes
    3 answers
15. average vs. last X values

    Asked by yakisoba, July 10

    0 votes
    1 answer
16. Counting Search Hits Across Fields On A Single Record

    Asked by viterbo, January 26, 2016

    • SQL
    • search
    • count
    • calculated field
    0 votes
    1 answer
17. Referencing aggregation in the footer

    Asked by ray985, June 16

    • aggregation
    0 votes
    1 answer
18. Counting and limiting submissions

    Asked by Smashley, June 21

    0 votes
    1 answer
19. Automated sequence number is child form

    Asked by vanderLeest, May 30

    • sequence number
    • child form
    • one to many relationship
    0 votes
    2 answers
20. Calculate Week Number in Formula Field

    Asked by NeoInJS, May 17

    • formula field; week number
    0 votes
    1 answer
21. Using external parameters in calculated field

    Asked by ray985, April 5

    • calculated field
    • parameters
    0 votes
    2 answers
22. Calc Field (-)

    Asked by ezIQchad, March 31

    • minus
    • subtract
    • calc field
    • calculated field
    0 votes
    2 answers
23. formula Multiple Consequential Formula Functions

    Asked by Esraaa, April 7

    • function
    • multiple
    0 votes
    1 answer
24. apostrophe Cell's Text with Apostrophes

    Asked by Esraaa, April 6

    • function
    • formula
    0 votes
    2 answers
25. Tire Hrs Calculation

    Asked by mdav20, March 31

    0 votes
    2 answers