Calculations and aggregations

257 questions in this forum

1. SQL count calculation issue

   Asked by LynnR, April 9, 2019

   0 votes
   4 answers
2. Convert a datediff to dd:hh:mm

   Asked by KAPITYAN, September 12

   0 votes
   2 answers
3. Can I get Caspio to total results in a column?

   Asked by aubreycohen, January 19, 2010

   0 votes
   4 answers
4. Concatenate fields without leading spaces

   Asked by KAPITYAN, August 29

   0 votes
   3 answers
5. Extra spaces

   Asked by Batchini, July 30

   0 votes
   2 answers
6. SQL contingent on a Select2 field

   Asked by Roderick, June 6

   • calculated field
   • sql
   • select2
   • select
   • cascading field
   • hidden value
   0 votes
   1 answer
7. Use 'contains' in a calculated field

   Asked by DesiLogi, June 19

   • calculated field
   • syntax
   0 votes
   2 answers
8. COUNT or tally Yes / No fields in Totals/Aggregates

   Asked by roattw, January 24

   0 votes
   3 answers
9. Formula to get the percentage contribution of each record

   Asked by astroboy, June 29

   0 votes
   3 answers
10. Task to update a field value in one table with the max value of a field in a subsidiary table

    Asked by vanderLeest, June 23

    • max
    • top1
    • task
    0 votes
    1 answer
11. select count in a report with search filtering

    Asked by sorin14, June 18

    0 votes
    0 answers
12. Remove string value from text string in formula

    Asked by DesiLogi, June 4

    • formula
    • string
    0 votes
    1 answer
13. Comparing Date field to constant to assign value

    Asked by hmsmorgan, May 29

    0 votes
    1 answer
14. How to apply custom formula for sub-groups in aggregation

    Asked by ttanemori, March 15

    • aggregation
    0 votes
    1 answer
15. Using a task to "export" aggregate, unique values

    Asked by Libby, May 8

    0 votes
    1 answer
16. Calculating Values from Time - MPH and Pace Per Mile

    Asked by FishTacos, May 6

    0 votes
    1 answer
17. Date format

    Asked by telly, January 25

    0 votes
    2 answers
18. Excel formula to Capsio

    Asked by capsio88, April 8

    0 votes
    2 answers
19. CASE statement returns a blank value no matter what

    Asked by NickO, April 23

    0 votes
    2 answers
20. Case Select with division and authorization

    Asked by Ras2019, April 20

    0 votes
    1 answer
21. Display aggregate of total time as HH:MM

    Asked by guardmetrics, March 12

    • aggregate
    • totals aggregation groups
    • totals
    • total
    • datediff
    • date
    • dates
    • formula
    0 votes
    4 answers
22. Php login page

    Asked by LIVINGSTONE, April 5

    0 votes
    1 answer
23. SysDateTime and GetDate Timezone

    Asked by taylorswiftlover, March 28

    0 votes
    2 answers
24. Check if File Field is Blank

    Asked by IamBlossom, March 22

    0 votes
    1 answer
25. Calculate Time

    Asked by telly, March 21

    0 votes
    1 answer