Post Author: Bpilot
CA Forum: Formula
Hello,I have another problem with which I need help but unsure of how to do it. I am trying to write a formula that will do the followingIf the last action is not FOL (Change Follow-up Date), then leave it as it is.If the last action is FOL then Select and display the next most recent action code.If the only action taken on an account is FOL then display nothing.I have included a screen shot of what my report includes as per the detail lines.The report is normally displayed only in the group footer, so as to display the last record entered per client.There is 1 group, which is based off the field {ARACCOUNT.ARACCLACCT} (Clients account number - not included in the picture). Action Date Action Code Action Code Description Next Action Can someone help me write the formula or push me into the right direction.