I’m currently trying to determine when an account status changes from one status to another. I’m ultimately trying to figure out what month a status changed to closed in.
One thought that I had was to compare the tempo account status from last month to this month. Do you know it that is possible?
SOMEHOW FIND LAST MONTHS VALUE ([Account].CurrentMember.getstring(‘Account status’)) != [Account].CurrentMember.getstring(‘Account status’) = SHOW THE CURRENT VALUE
Again, I’m trying to derive when an account status converts from open to closed or archived.