Get fieldvalue In Chart

[orital81]

Hi, I am working on Material Balance model.

My current goal is to develop a Forecast view of the Material.

I have created a Straight Table that presents;

Forecast = sum of Act Stock+ all previous Purchase Orders - All Previous Sales Orders

I need to update the Act Stock of each Quarter as the closing forecast

of the previous Quarter. (See screenshot below).

I thought using the function FieldValue('Forecast',n) but I get Null values for any n number.

I will appreciate any approach.

Thanks

[swuehl]

Ori Tal,

is you Forecast a field or do you calculate in the chart?

I think you could probably use chart inter record functions for that, something like above(Forecast) as (partial?) expression to update your actual stock. Or put your expression to calculate Forecast in the above function above(sum(ActStock)+...)

Please have a look into the different chart inter record functions, also into rangesum(), they are really helpful for things like this.

If you upload a small sample, I or someone else here in the forum is probably able to help you with the syntax.

Regards,

Stefan

[orital81 · Accepted solution]

Hi Stefan,

Thanks for the quick reply and the Tip.

I used RangeSum and Above functions as shown below and it workws perfect:

Top(Sum(Forecast_ActStock))+rangesum (above(sum(Forecast_PO),1,4)) -rangesum (above(sum(Forecast_SO),1,4))