Good day
I would like end users to be able to configure a time and then be able to use this time in various KPI calculations in the Views that we are building.
I created a Runtime variable (package level) called COTime_USD, I then configured input-box Form Component in a view and set this to data type: time (the input-box can also take “date”, “number” and “string”). I would then like to use this variable ${{COTime_USD}} in calculations and typically add it to a date (ie ROUND_DAY("o_custom_Payment"."Date").
I have seen for dates, the variable needs to look like this in order to get it to work in calculations: {t ${{COTime_USD}} }, but I am not sure what I should use in stead of the “t” to define it a time.
When I try to execute the calculation I get stuck at “Syntax error near :]...”. I have tried the following calculations:
- ROUND_DAY("o_custom_Payment"."Date") + ${{COTime_USD}}
- ROUND_DAY ( "o_custom_Payment"."Date" ) + {t ${{CutOffTime_GBP}} }
- TO_DATE(TO_STRING(ROUND_DAY ( ""o_custom_Payment"."Date"" ))||' '||TO_STRING (${{COTime_USD}}))
-
TO_DATE(TO_STRING(ROUND_DAY ( "o_custom_Payment"."VALUEDATE" ))||' '||TO_STRING ({t ${{CutOffTime_USD}}}))
Any suggestions on how I can make this work?