Bug 410062 - Add support for calculated fields in tables
Summary: Add support for calculated fields in tables
Status: CONFIRMED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 3.2.0
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: Kexi Bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-07-21 09:56 UTC by Rony Islam
Modified: 2019-07-21 11:20 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Query fails to perform simple calculation. Also Criteria in the previous field shows additional (") mark annoyingly (169.67 KB, image/jpeg)
2019-07-21 09:56 UTC, Rony Islam 		Details
View All Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Rony Islam 2019-07-21 09:56:51 UTC 
Created attachment 121659 [details]
Query fails to perform simple calculation. Also Criteria in the previous field shows additional (") mark annoyingly

It is frustrating to see how little is progressed in Kexi project since 2005 in contrast to MS Access in 2019. Kexi still doesn't have a dedicated calculated field in tables. One has to create a query to perform simple calculations like Addition or Multiplication.

Also the calculation criteria in query is extremely buggy. It creates confusion more so often. Just look at the attachment and you will see what I meant. Please help with some workaround.

SUMMARY


STEPS TO REPRODUCE
1. 
2. 
3. 

OBSERVED RESULT


EXPECTED RESULT


SOFTWARE/OS VERSIONS
Windows: 
macOS: 
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 
Qt Version: 

ADDITIONAL INFORMATION
Comment 1 Rony Islam 2019-07-21 10:00:52 UTC 
Every time I open my query to try different method to perform a simple calculation: "FinalSalePrice = SalePrice + (SalePrice * TaxRate /100)". It shows "invalid criteria" and also additional (") sign is added to the previous field criteria.
Comment 2 Jarosław Staniek 2019-07-21 11:20:21 UTC 
Thank you Rony, changed to wish.