Jan H
My feedback
7 results found
-
1 voteJan H shared this idea ·
-
1 voteJan H shared this idea ·
-
7 votesJan H shared this idea ·
-
98 votesJan H shared this idea ·
-
2 votes
An error occurred while saving the comment -
8 votesJan H shared this idea ·
-
139 votes
Thank you for this idea. We are looking into adding this feature in future product updates.
An error occurred while saving the comment Jan H commentedCalculated fields in views shoud have been an obvious feature. Alternatively, there could be a feature for creating views "from scratch" in some kind of a "SQL-bulider". I suggest a feature something like the MS Query built into Excel, where you ca build a query, and then later edit the SQL with joins, criterias, calulations, headings, formats and so on.
Is this not possible usin SQL in calculated fields?
Something like this:
Beginning balance:
SELECT transactions FROM table WHERE period < nowperiod AND cust = [@custid]
Transactions this period:
SELECT transactions from table WHERE period = nowperiod AND cust = [@custid]
Outgoing balance:
Beginning balance + transactions this period.