Function of Character

[pgalvezt]

Hi,

I have a pivot table where I have fields loaded from other app and just call thats fields in my second app. But in the others columns I have formulas that brings last month. The formulas are right, But I have one field that shows Character So.

Column A (only the field)  Column B

Character1                                  -

Character2                          -

So on

In coIumn B I have to bring Character1 Character2 (Comparison columns) but with the last month and same day, Example if in Column A Brings 13-08-2014 in column B Should brings 13-07-2014.

My formula is

=Sum({<fecha={'>=$(=Date(Max(fecha) - 31))<=$(=Date(Max(fecha) - 31))'}>} Inv)/2

Where Inv is numeric This bring me Same day last month

=Sum({<fecha={'>=$(=Date(Max(fecha) - 31))<=$(=Date(Max(fecha) - 31))'}>} Per)/2

Where Per is a character so, Column B brings null values.

How can I show character in set analisys?

Thanks!

[#2 · Accepted solution]

You can try ONLY or Maxstring functions, as Set analysis can be used only with aggregation functions.