Data Model with Calculations
Hi,
I am creating a data model using standard SQL query where I want to have a calculated column. My select statement is as follows:
SELECT
"Table"."Field1" as "Field1,
"Table"."Field2" as "Field2,
"Table"."Field1" - "Table"."Field2" *.3 AS "Field3"
FROM "Table";
I keep getting an error message not able to load SQL. Can you advise how I can go about resolving this and getting the result I need?
Thanks!