I have a table with a few columns, I need to generate a graph that sum the Column AQN_Vol_Baseline_IVA if the column AQN_Fecha_R_Adj.Day is between 1/1/2010 and 31/3/2010. The first field is a number and the second is a date.
Alex, thaks so much for your quick answer, I think I´m doing something wrong....I change some field names but I can show you what's going on:
sum({$<date([Fecha Real de Adjudicación])= {">= 1/1/2010 <= 31/3/2010"}>} [Volumen Baseline Año 1] )
I detect that the field [Fecha Real de Adjudicación] is not in the format 1/1/2010 and I use date([Fecha Real de Adjudicación]) but something is wrong...
Fecha Real de Adjudicación
date ([Fecha Real de Adjudicación])
sum({$<date([Fecha Real de Adjudicación])= {">= 1/1/2010 <= 31/3/2010"}>} [Volumen Baseline Año 1] )
So far as I know, you can't use set analyis on expressions, only on fields. In other words, I don't think you can use a function on [Fecha Real de Adjudicación] inside of set analysis. You CAN specify expressions in the search expression using dollar sign expansion, but that's completely different.
My suggested solution would be to format [Fecha Real de Adjudicación] as a date either with a date() function in the load, or by going to document properties, number, select the field, select "Date" as the format, specify the format pattern, and checkmark "survive reload". Then simplify your expression as follows:
sum({<[Fecha Real de Adjudicación]={">= 1/1/2010 <= 31/3/2010"}>} [Volumen Baseline Año 1])
If you WANT to keep it formatted as a number most of the time in your document, you will have to convert your two dates to the same numeric format. If they are literals like you show, just use the equivalent numeric literals:
sum({<[Fecha Real de Adjudicación]={">= 40179 <= 40268"}>} [Volumen Baseline Año 1])
