Hi I need to calculate, SUM of a new and lostcustomer sales past two years. Lost= made sales last year, but not the selected year New= sales made selected year but not last year
Good morning, i applyed this formula to calculate the number of lostcustomers: count({$<PeriodCounter=,CLIENT_NAME={'=sum({1<PeriodCounter={"$(=max(PeriodCounter)-1)"}>} [Bill Amount])&g...
Hi, I am trying to build table with new, returning, lostcustomers. Data is of last 3 years-2015,2016,2017 NewCustomer - Customer in 2017 only Returning customer- Was customer in 2015, n...
...er is the average revenue of the last 3 months prior to the current month. Same goes for revenue from newcustomers. An excel file is attached to explain how to calculate the lost revenue. R...
Dear all, i need your help in order to calculate lostcustomers. I know well that it's not easy. Lostcustomer for me is : customer without revenue in the last 6 months I found an a...
Hi. I have a data set where I am trying to show lostcustomers. I have created a lostcustomer Indicator that shows a 1 for a lostcustomer, and a 0 for non-lostcustomers, based in w...
...hen a newcustomer is created in source system, i currently need to reload the job and the whole data are processed by the tMatchGroup.
If i have 10 000 customers, the job will process these 10 0...
Hi,
i have a list of customers with invoice history.
for example:
now i want to count all the distinct customer names that do not have an invoice date with year 2022. but i h...
...alculate in an expression (like in a Text & Image in sense) that the number of customers who bought in 2016 (between 01/01/2016 and 12/31/2016) also bought in 2017 (between 01/01/2017 and 12/31/2017)....
Hi there
I'm new to TOS and the world of ETL and data integration, I've worked with python directly but I'm having a few issues using TOS to try and populate a custom Salesforce object w...
