Calculated dimension in INLINE table!

[#1]

Hi

I have INLINE table as given below. I want to add one more field in that table. Which Should be calculated like this(=Mid([Forecast Display], 2)). Could you please suggest me how that could be done.

[Chart]:
LOAD * INLINE
[Range
a3.5
a4
a6
a8
a12
];

[#2]

I have done something like below and it works but it is manual. Still wanted to know is there is any way of doing that with calculated dimension.

[Chart]:
LOAD * INLINE
[Range,Range1
a3.5,3.5
a4,4
a6,6
a8,8
a12,12
];

[deepakk]

hi Attitude,

use function mid and try it out

mid(Fieldname,2, len(filedname))

[#4]

Thanks Deepak

Yes I know that. But is it possible to do the calculated dimension in a inline table. Please check and let me know!

[deepakk]

hi Attitude,

Below is the code. Instead of load * inline use the field names.

LOAD

F1,mid(F1,2,len(F1)) as tt INLINE

[

F1,

122

33

33

;