Storing values in saved variable/array/etc..

[Former Member]

Hi,

I want to count the number of records(materials) where those material evaluation type equals to 'gmat' for an year and from these records count the materials which also have the material evaluation type <> 'gmat". Since both conditions are mutually exclusive then I tried to get by using arrays. But arrays are limited to 1000 elements so I can't build them infinitely.

Note: Material can have multiple 'material evaluation types' in a year...

Can somebody help me out to solve this or any suggestions heartily welcome.

Thank you,

Best Regards,

Siddi

[Former Member · Accepted solution]

Hi Siddi,

You can create a formula to get this count .

if {material evaluation type } = "gmat" and =2008

Then 1 else 0

Place this formula on your detail section and insert a summary on report footer.

If you can give us the required output then it will be very helpful to answer .

Thanks,

Sastry

[Former Member]

Try creating running total in which add the summsry as count and in evaluation write the condition like

Evaluation Type='gmat' and year=2008

and place this in the detail section which counts the nuber of records.

Regards,

Raghavendra