how to evaluate and other condition in running total's formula 1

[kuekue]

In Running totals under Evaluate i want a formula to read,

distinct({field}) and {field} > 0

except that the distinct function doesnt exist. What else could i use instead?

 

[Madawc]

What are you wanting the function to do? Distinct Count is a way of counting something like the number of account numbers without counting the same account twice.

There is a maximum and minimum function in summary totals, does that help?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[kuekue]

I mean i need to use 'running total' and i need to use 2 conditions
1. evaluate (field)
2. evaluate on change of (field)

I can use only 1 condition but i don't know how to create formula for use 2 conditions

******
ex.data
*******
field1 field2 field3
08001-9 520107001 2253000.00
08001-9 520107001 2253000.00
08001-9 520107001 2253000.00
08001-9 520113001 1180000.00
08001-9 520113001 1180000.00
08001-9 520113001 1180000.00

i need to sum (field3),
reset on change of group (field1),
evaluate on change of (field2) and
evaluate (field4[date]) = currentdate


Thanks,

 

[lbass]

Change your evaluation formula to:

(
onfirstrecord or
{table.field1} <> previous({table.field1}) or
{table.field2} <> previous({table.field2})
) and
{table.field4} = currentdate

-LB

 

[kuekue]

Wow!! I think it can solve a problem .

Many Thanks,