Expression.

[deepakqlikview_123]

Hi All,

Below is expression that I have used previously for calculating Max years vehicle number

count( {$<Year= {$(=Max(Year))}>} VehicleSerialNumber)

But now i have changed Year to Billing_Year1.

Can you please suggest what would be expression in this case.Because my expression is not working fine.

Thanks,

[#2]

Count({<Billing_Year1={$(=Max(Billing_Year1))}>}VehicleSearialNumber)

[jagan]

Hi,

Can you explain in detail with some sample file?  If you are changing field name Year to Billing_Year1 then use this

=count( {$<Billing_Year1= {$(=Max(Billing_Year1))}>} VehicleSerialNumber)

Regards,

Jagan.

[#4]

Hi

If you are using Billing_Year1 field for year then you can use this

=Count({<Billing_Year1={$(VMaxYear)}>}VehicleSerialNumber)

Variable:

VMaxYear= Max(Billing_Year1)

Still you are not getting the proper output. Attach the sample file

Regards

Nirmal