This content has been marked as final.
Show 2 replies
-
1. Re: Create empty dates ?
Sohan Jawar Jul 10, 2018 6:47 AM (in response to François Jacquemart)Create parameters Jan 18, Feb 18 etc. which will become columns with the same value.
For active/inactive users, you can try calculation like
Active/Inactive = If Current Period End>=Today() Then "Active" ELSE "Inactive" END
Then Active Users = IF Active/Inactive = "Active" THEN 1 ELSE 0 END
Inactive Users = IF Active/Inactive = "Inactive" THEN 1 ELSE 0 END
Regards
Sohan.
-
2. Re: Create empty dates ?
François Jacquemart Jul 10, 2018 7:43 AM (in response to Sohan Jawar)Thanks for the reply Sohan ! Will definitely try the 'parameters dates' !
The problem is that for example a user Who was active from Jan 18 to May 18 (Current period end May 18) will be counted as Inactive and the main problem here is that I want to count him as active in months 1 2 3 4 5 2018 and inactive in months 6 7 2018.