inputsum not working

[#1]

Hi

I have the following expression providing me with the forecast KG value:

Sum({$ <Forecast.ForecastType = {"KG"}, Forecast.ForecastVersion = {"Current"}>}Forecast.Value)

In order for the Forecast to be amended via QV i was hoping to use the following coding (and a few variations) but this doesn't appear to work.

inputsum(Sum({$ <Forecast.ForecastType = {"KG"}, Forecast.ForecastVersion = {"Current"}>}Forecast.Value) )

Please can you let me know what I am doing wrong.

Thanks, Gareth

[tseebach · Accepted solution]

You need to cast the field as inputfield in the script.

Add

inputfield Forecat.Value

to your script. I'd however advise you to precalculate the value of the field in the script, since having a set declaration might give unwanted results.

[#3]

Thanks