Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please find attached sample application and data.
logic:we are comparing the latest month date with previous month date.
1.The cust who are present in latest month and not in previous month as addition,
2.The cust who are present in previous month and not in current month as deletion
3 remaing all are null i.e cust present in both the date.
Regard
Arun Reddy
See attached qvw. Your data is not very clear. There are no weeks, but two dates from two different months. And your employees seem to change their names during time. So I could only use the two dates 'hardcoded' in the expressions and only the EMPLID as dimension.
Hi Gysbert,
Thanks for replay,
Please attached the qvw file, we need to create the new field ie output in back end.
logic is clear :
consider the latest month is 'Jan' compare with previous month 'Dec' ,if new employees added in the latest month as addition,some of the employees left the job as deletion,
Thanks
Arun Reddy