FieldValue problem

[DiaEli1980]

Hello

I have a trouble with my app, I have some tables that are loading to excel files, I need to put an especific value in a KPI control it shoul change when I select a diferent date.

The problem is that fieldvalue function only accept strings, I need link a variable that function.

I am using the following formula:

if($(MesFiltro)='abr*',FieldValue('% CUMPLIMIENTO SD',RowNo()),'no funciona')

Maybe someone know any function to seach in a table like vlookup in excel.

[vikramv]

Hi ,

There are many other ways to do this like LookUp , Peek etc... 

In your case,Peek would be the easiest way.

Try replacing Field Value with Peek.

Thanks.

Vikky