Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to replicate an existing report created by a SQL stored procedure.
The field AvoidableDays is defined as INT in the stored procedure. As a result the decimal values of the data are ignored when summing.
For example the raw data might calculate as 4 & 5.7 for Avoidable Days for 2 rows.
The stored procedure is showing the sum of these as 9. Qlik however is showing the sum as 10.
Here is the expression I have in my script to calculate this.
If (("LENGTH_OF_STAY"-"GMLOS")>0,("LENGTH_OF_STAY"-"GMLOS"),0) as AvoidableDays,
My expression is the same as the stored procedure. But Qlik is treating the raw data differently than SQL.
How can I modify the expression in Qlik to drop the decimals and do what the Stored Procedure is doing?
I need to have my numbers in Qlik match what they are currently seeing. Even if it is wrong.
Hopefully this makes sense.
Check for Floor() and Ceil() functions
Check for Floor() and Ceil() functions