Is there a way to get the values of cells via scripting?

[PatriciaR55]

The user would like to be able to show a message on the following conditions (only if value and quantity is not filled):

• price is 0,
• price is blank,
• price is negative or becomes +/-50% more than historical price.

We tried using getSelections() but only dimensions are available.

Is it possible to get measure values via scripting to enable a check as mentioned above?

[david3030]

Hello,

did you tryed to use getResultSet({yourselection})

regards

[PatriciaR55]

Hi David, thanks I tried this and was able to see the measure values.

However, I am using a forecast layout with actuals and forecast version and realized I only get the actuals version even if I select on the cells for forecast version. Is this expected?