How to evaluate the value of a field in my expression

[#1]

Hi,

I have an inline table like this:

FMSTextSintesi:

Load * Inline

[FMSDim,FMSVal

PB Attivi, count({$<attivoPO={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB)

];

What I'm trying to do on the designer is create a linear table with the field "FMSDim" as dimension and for expression I'd like to put the "FMSVal" value.

Obviously this way give me as result of the expression a text. The text in the field "FMSVal" ( count({$<attivoPO={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB) ).

Is it possible to evaluate the value of the field in my expression so I have the result I'm expecting to have??

Thanks in advance

Giampiero

[#2]

use $(FMSVal) in the expression

[Gysbert_Wassenaar]

See here and here.

[#4]

HI,

thanks for your reply.

Unfortunately I already tried that solution but it doesn't work.

Thank you

[#5]

Thank you Gysbert,

I'll try read it.

I'll tell you later

Giampiero

[#6]

Hi

You can use this in your expression if you are not using FMSDim as your dimension.

=$(=Maxstring({1<[FMSDim]={"PB Attivi"}>} [FMSVal]))

If you are using FMSDim as a dimension in the same chart then the below should work

=$(=Maxstring([FMSVal]))

Thanks & Best Regards,

Kuldeep Tak

[#7]

Hi Kuldeep Tak,

Thank you.

I'm using FMSDim as a dimension.

I tried your expression:

=$(=Maxstring([FMSVal]))

but it doesn't work.

FMSTextSintesi:

I write my complete table.

Hope it helps.

Load * Inline

[FMSDim,FMSVal

PB Attivi, count({$<attivoPO={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB)

di cui attivi SEI, count({$<attivoPO={'SI'},attivoSEI={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB)

di cui con iDesk, count({$<attivoPO={'SI'},attivoIdesk={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB)

];

Thank you

Regards

Giampiero

[#8]

Hi Kuldeep Tak,

I know why your expression doesn't work in my case.

=$(=Maxstring([FMSVal]))   works perfectly if in my espression there are'nt comma ",".

I tried without it, and it works.

Unfortunately my expression in the field are:

count({$<attivoPO={'SI'},meseStorDati={'Ultimo Agg.'}>} codicePB)

and as you can see there is a comma.

When I put this expression in the Load inline the script thinks that the comma works to have another value of another field.

Hope it's clear.

Now I have to understand how to go through this problem.

Any idea?

Thank you so much

Regards

Giampiero

[#9]

Hi,

Instead of using an INLINE table, put the values in an excel file and load it from there.

This is what I am doing to develop the business glossary.

Thanks & Best Regards,

Kuldeep Tak

[#10]

Hi,

I was trying the same way.

Unfortunately it doesn't work.

Maybe I made a mistake.

I attach you an image.

What do you think?

Regards

Giampiero