Click here to Skip to main content
15,941,828 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I was trying to sum of leaves in crystal report. My formula works on one employee but when i tried to get the report of all employees it gives error " A number or currency field is required".

What I have tried:

If IsNull(Sum ({Table.CL_AV}, {Table.empcode})) then
Sum ({Table.CL_CR}, {Table.empcode})
else
Sum ({Table4.openignbalcl}, {Table.empcode})-Sum ({Table.CL_AV}, {Table.empcode})
Posted
Updated 9-Sep-18 7:40am

1 solution

Take a look here: A number field or currency amount field is required here[^]
A solution is to use ToNumber() function.
 
Share this answer
 
Comments
Member 12962919 10-Sep-18 0:49am    
Can you tell where to add Tonumber. before sum or after sum. Because when add it after sum its gives error to many argument.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900