GetNthRecord with a nested Get Field Name??
I have a problem in where I need perform conditional formatting on field values from one record to the previous record, I know I can do this using the Self≠ GetNthRecord (SHOWS::W1A ; Get(RecordNumber)-1) formula but I need to apply this to over 400 fields and I don't really wish to provide an independant cell reference for each.
I tried Self≠ GetNthRecord (Getfieldname(self); Get(RecordNumber)-1) but get the error "In the function Average, Count, Extend, GetRepetition, Max, Min, NPV, StDev, Sum, GetSummary or GetNthRecord, an expression was found where a field alone is needed."
Does anyone know a work around or script solution to get around the field alone is needed restriction?