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
·
-
95 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
commented
Calculated 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.