Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Count({<Billing_Year1={$(=Max(Billing_Year1))}>}VehicleSearialNumber)
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.
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