I'm getting data using a query in Delphi, and would like to add a calculated field to the query before it runs. The calculated field is using values in code as well as the query so I can't just cal...

I know similar questions were asked before, but none of the answers that I found (example here, another example) helped me. What I am trying to do: Create a report in Google Data Studio that sh...

Newbie in SQL and development in general, I have a table (COUNTRIES) with fields (INDEX, NAME, POPULATION, AREA) Usually i add a client side (Delphi) Calculated field (DENSITY) and OnCalcField : CO...

How can i sum a data set that has been eager loaded? This is my table structure: regions table +------------+------------------+------+-----+---------------------+----------------+ | Field | Type |...

I am tormented by the question: where I should locate my calculated properties in angular project? For example: I have model, service to get model and component to show model. person.model.ts: e...

For testing purposes (before I apply on my big code) I decided to pipe an array of string to convertTo-html hoping to create some kind of table displaying my array. [String]$servers= @('GT544', 'H...

I looked this issue up and did not find any sufficient solution for myself. I am trying to create a Calculated Field through Google Sheets Pivot Tables and I'm getting the #NAME? error. To my bes...

Using Django ~=1.11 and Python 3.6 I need to store 'calculated' variables as fields in the Django model database. Here's a model: from django.db import models from datetime import date class Pe...

I'm working with pivot tables in excel and historical monthly returns for different mutual funds. I'm trying to calculate the historical monthly returns of each fund net of all management fees. So ...

I have the following piece of code which counts how many times something appears in the event column. SELECT event, count(event) as event_count FROM event_information group by event event event...

I have a field such that Color Pink Blue Pink Blue Pink Pink Pink Pink Pink Blue Blue Pink Pink Pink Blue Pink Blue Pink Blue How to create calculated field to count number of times Pink appears...

I am in the need to add additional fields to a TDataSet that don't exist in the underlying database but can be derived from existing fields. I can easily do this with caclulated fields and that wor...

I have a Core Data project and am having difficulty searching the data with a simple calculated field and have no idea why it's not working. I have a Tutor entity, with core data string attributes...

I have an invoice model, that "has many" invoice items. I have a form that allows you to create/edit an invoice, and this form accepts nested attributes for the invoice items. In my invoice model,...

I have a table with several account fields like this: MAIN_ACCT GROUP_ACCT SUB_ACCT I often need to combine them like this: SELECT MAIN_ACCT+'-'+GROUP_ACCT+'-'+SUB_ACCT FROM ACCOUNT_TABLE I'd...