Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks