Post Author: cht104
CA Forum: Formula
I've created a report to show number, date and amount. It works, but I want the numbers to be changed to a names in the group header only. I"ve tried several if / then or case statements, but keep getting different errors. Where should I create the formula? Is it a formula field or a SQL expression field?
I'm pulling 3 fields from 1 table; number date amount. The number column has a header of Group 1 Name. Group 1 Name is what I would like to use the IF expression
IF number = "12345" then Sam IF number = "54321" than Tom I've got multiple number -> name changes to make.
I know that I'm over thinking or trying to make more difficult than it should be and would greatly appreciate any help or suggestions.