Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You can try ONLY or Maxstring functions, as Set analysis can be used only with aggregation functions.
You can try ONLY or Maxstring functions, as Set analysis can be used only with aggregation functions.