ContributionsMost RecentMost LikesSolutionsRe: Merge data from two tables into one report Thanks for the reply, Mark. Going to one table is a helpful suggestion and I think gives me a path to solve this. Thanks!! ------------------------------ Stephen Jackson ------------------------------ Merge data from two tables into one report I am looking for help in making a report which will make nametags for the Contact, their spouse and any children associated with them -- each family size is different so some Contacts are single yet some are families of five. The Contact is saved in one table and the spouse & children are saved in another table. I've set it up so many spouse/children belong to one Contact. I thought I could easily combine this data into a third table. There I want to create a report which pulls the names of the Contacts and the names of the spouses/children and puts it all in one column, but I'm running into issues doing that. There should be a second column stating which Contact everyone belongs too, as well. Can someone please help me figure this out? Or let me know if there's a better way to organize this data? ------------------------------ Stephen Jackson ------------------------------ Re: Commas added to currency numeric field summariesHi Matt, Thanks for your help!! Your solution is still gives me an error where it says "Expecting number but found text" if the Report formula is a Formula - Numeric. Or if I change it to Formula - Text, it'll only summarize by Distinct Count in the Summarize Data section. Any ideas? It ------------------------------ Stephen Jackson ------------------------------ Commas added to currency numeric field summariesIn a Summary Report, I am trying to make the 'Report formula' columns display with a comma added every three digits. ex: $1,234,321.00 instead of $1234321.00 The 'Report formula' is summarizing a Numeric - currency field as Formula - Numeric. The Numeric - currency field's properties is formatted to include these commas. The commas appear when I look at an individual record. But the 'Report formula' column does not display them on the Summary Report. I have tried: ToFormattedText([Number - currency field], "comma_dot") but it receives an "expecting number" error. If add ToNumber at the beginning of that formula, it displays the value without the commas. Changing the 'Report formula' to a Formula - Text means I can't summarize the total. I can only count distinct values. Any ideas as to how I can add the commas? #Formulasandfunctions #reportsandcharts ------------------------------ Stephen Jackson ------------------------------ Re: Checkbox field labels on forms are always on the right. Why? Is there a fix?Hi, since javascript doesn't work on QB anymore, how would I now change the location of the text relative to the checkbox? Thanks! ------------------------------ Stephen Jackson ------------------------------ excel-like report/number of uniqueHi, Is there a way to make a report which has three different items as rows and simply displays whatever their totals are in the same column? This is very easy to do in Excel but I am struggling doing it in QB. If this can't be done, does anyone have any ideas as to how to solve this issue: We have two organizations. Each year, companies can pledge to be members of the two orgs. Some have two pledges for one year since they are members of both organizations. For a given year, I would like to produce a report which shows the total number of pledges to Org A and the total number of pledges to Org B. (I can do this part easily.) I then want a total which shows the total number of unique companies. The calculated field is essentially (# of Org A pledges + # of Org B pledges) - #of companies pledged to both orgs. I've got a field which tells us whether the pledge is to Org A or Org B. I've got a field which tells me if the company has two pledges and therefore should not be double counted. The issue arises in how to display this succinctly in QB. Ideally this would all appear in the same chart: Org A Pledges # of pledges Org B Pledges # of pledges Total Companies # of total companies This is easy to do in Excel. You simply calculate it and display it. But I can't figure out how to do it in Quickbase. Any ideas?? Thank you!! #reportsandcharts ------------------------------ Stephen Jackson ------------------------------ Display total records in report on homepageI have a number of Table Reports shown on the homepage of our app. When you display Full report for these reports, it shows a numeric summary of how many records are being displayed. (in the top right, above the table.) I'd like that number to appear with the report when it is displayed on the homepage. It doesn't matter to me whether the number appears above or below the table. These tables are displaying only text so I haven't been able to figure out a way to get a total at the bottom which adds up the above entries. I'd hate to make another column which just has "1" in it and then that total is added at the bottom. How can I get that number of records in a report to display on the reports which are embedded on my homepage? ------------------------------ Stephen Jackson ------------------------------