Hi All. I'm doing something wrong as I get this error: "A Summary has been specified on a non-recurring field. Details: @A_Count"
Formula @A_Count:
Code:
if {@A_Time} > 0
[highlight]and {usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC}<> Previous({usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC})
and {usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC}<> "<No Restriction>"[/highlight] then
1
else
0;
What I'm trying to do is to output 1 only if description changes (unique). I Sum this formula later to get count.
{@A_Time} formula simply converts time difference into minutes and have output as either minutes (234) or 0.
{usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC} field is in hidden details section.
Data in {usp_RPT_RW_CONDS_TIME;1.TIRE_CHAIN_RSTRCT_DESC} is like this:
<No Restriction>
Condition A
Condition B
Condition C
It all worked, counting, until I added highlighted section in the code above.
Anyone can advise me on this?
Thanks. CR is ver. XI