Our reply to this mail was as follows:
Kindly find below the explanation of the error that occurred in the query,
The engineer responsible for the query made the step of changing the type of the columns in the query but the type of the columns “All floors” and “Foundation” was not similar to the rest of the columns such as “Water Tank”, “Ground Floor” and the rest of the floors of the project causing the 0.01 value to turn into 0.
To solve this issue, the type of the columns “All floors” and “Foundation” must be changed to “number” instead of “int64” so that the value 0.01 can be counted as 0.01 and not 0.
Kindly find attached two screenshots of the query showing the difference before and after making the steps I mentioned above.
- This reply was modified 1 month, 2 weeks ago by Abdelrahman Sallam.