Select the "N Text" value from a dual field

[cristian_av]

Hi

I have a dual field in my master calendar called Cal_ID_MesAnoEP wich contains an integer and a text. The integer represents the number of payment, and the text shows a date and payment number.

I'm trying to use Point in Time Reporting with this value.

I have no trouble using the integer field, I can get the N period back values using the following statement:

=Sum(     {$<Cal_ID_MesAnoEP={"$(=Max(Cal_ID_MesAnoEP)-N)"},        Cal_AnoEP=,Cal_MesEP=>} CantidadServicios)

But I don't know how to get the the text field for N period back.

How can I do it?

[Anonymous]

text(Cal_ID_MesAnoEP) should return the text representation.

[cristian_av · Accepted solution]

For some reason I don't understand the text function returns the number but as text.

Finally I solved with MaxString:

MaxString(     {$<DualField={"$(=Max(DualField)-N)"},        Cal_AnoEP=,Cal_MesEP=>} DualField)

Thanks!