Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV Experts
When i select the Month ' July' from the list box, i was surprised to see one additional rows.
After analysis i found due to the Newserv Id, though the Acknowledgement Sent Date Column in Jan 2016, it displays in July 2015.
The Expression used,
= Count({<DateType = {'Received'}>}Acknowledgement)
Can you please suggest me how to get rid of this duplicate row.
Maybe like attached.
I've removed the syn table by dropping one table and changed the key for the link table.
Excellent. The same was expected. Thanks a lot.