Skip to main content

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?

Be the first to reply!

Reply