AM7 Show formula column in report
This one has me and our sims guru stuck.
We are redesigning our reports so that they look nice. One part of this, is a column that tells parents if their child is on target, off target or over target (with off target colour-coded red, on target green etc.). We've created a formula column in sims am7 that does this but we can't for the life of us export this into the word report.
The formula column doesn't seem to exist when we look to insert this in the mail merge and word doesn't do conditional formatting, so there was no way of doing it there either.
How can we achieve this? Is it possible?