Hi,
I am really sorry for not giving the full details. I have 3 formula fields in the detail section.
1) {@skills}
2) {@status}
3) {@percentage}
{@skills} has
whileprintingrecords;
numbervar CountSkills;
if {table.MCSLocation}="none" then
(
"Not Covered";
)
)
else
(
CountSkills := CountSkills + 1;
{table.skills};
);
{@status} has
whileprintingrecords;
numbervar countStatus;
if {table.skills}="None" or {table.skills}="none" then
(
countStatus := countStatus + 1;
"N/A";
)
else
(
if not isnull({table.skills}) then
(
if {@statusOff}<>"999999" then
(
countStatus := countStatus + 1;
{@statusOff}; //this displays "Off"
)
else
(
if {@not active}<>"999999" then
(
countStatus := countStatus + 1;
{@not active}; //this displays "Not active"
)
else
...//other conditions
{@statusOff} has //which is a inner formula inside {@status}
if mid({table.status},1,2)="ad" and {table.adon}=0 then
"Off"
else if mid({table.status},1,2)="ap" and {table.apon}=0 then
"Off"
else if mid({table.status},1,2)="dc" and {table.dcon}=0 then
"Off"
else
...//it goes on to check 27 conditions
{@percentage} has
whileprintingrecords;
if isnull({table.WeightedPercent})=true or {table.MCSLocation}="None" then
(
""
)
else
(
{table.WeightedPercent};
totext({table.WeightedPercent},0)&"%"
);
These are the formulas that i use and the data generated looks like
Skills Status %
AP 3.25 Mastered 100%
AP 3.25 Mastered 100%
AP 3.25 Mastered 85%
PR 0.90 In progress 10%
NC 2.60 Not Mastered 20%
DC 1.90 Mastered 100%
Here Skills is {@skills}, Status is {@status} and % is {@percentage}.
If you need anything else then please let me know.
Thanks,
Manish