G
gholly
hi! I want to do a % to LY comparison in the Group Footer, but can't seem to
figure it out. Can anyone help me with this?
Here is an example of my data:
Year Group Units
2002 G1 100
G2 50
G3 35
2003 G1 250
G2 45
G3 60
2004 G1 175
G2 85
G3 70
Already in my footer, I have the sum of Units for the year. And what I want
to compare is the total units per year to the total units for the previous
year - as a +/- percentage. And wherever it is negative, I would like it to
be in the color red. Is this possible?
I'm not great a code, and work mostly in the Design Preview of the
report...so an explanation this way would be easiest...
I hope someone can help me figure this out! Thanks in advance.
figure it out. Can anyone help me with this?
Here is an example of my data:
Year Group Units
2002 G1 100
G2 50
G3 35
2003 G1 250
G2 45
G3 60
2004 G1 175
G2 85
G3 70
Already in my footer, I have the sum of Units for the year. And what I want
to compare is the total units per year to the total units for the previous
year - as a +/- percentage. And wherever it is negative, I would like it to
be in the color red. Is this possible?
I'm not great a code, and work mostly in the Design Preview of the
report...so an explanation this way would be easiest...
I hope someone can help me figure this out! Thanks in advance.