Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like a sum of customers who depends on two condtions of sum
I made the following calculation but that does not give me the good result.
sum( {<[Code Client]={"= sum ({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde )>2 and
sum ({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde )<=5 "}>} Occurrence_Client )
Can you help me? Thank you
May be you need this
=Sum({<[Code Client]={"=Sum ({1<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) > 2 and Sum ({1<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde )<= 5"}, [Date Commande]={">=$(=vDate24mois) <=$(=vDateFinSeg)"}>} Occurrence_Client)
Expression sees okay, What it can be used of 2 double quotes in your nested analysis?
Have you tried to create a chart with Code Client as a dimension and these two expressions to see if any of the code client meet the criteria?
=Sum({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) > 2
=Sum({<[Date Commande]={"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) <= 5
excuse me I did not understand your question.The only thing that is used between the quotes are notions of dates
yes, and I have clients who meet both criteria
thanks
If that is the case, then I don't see why it isn't working.... Can you add this expression to the table above
Sum({<[Code Client] = {"=Sum({<[Date Commande] = {"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde ) > 2 and Sum({<[Date Commande] = {"">=$(=vDate24mois) <=$(=vDateFinSeg)""}>} Occurrence_Cde) <= 5"}>} Occurrence_Client)
too bad but it doesn't work
thanks
Can you share application to investigate where this not working?
What are you getting when you use this?
Sum({<[Code Client] = {"=Sum({<[Date Commande] = {">=$(=vDate24mois) <=$(=vDateFinSeg)"}>} Occurrence_Cde ) > 2 and Sum({<[Date Commande] = {">=$(=vDate24mois) <=$(=vDateFinSeg)"}>} Occurrence_Cde) <= 5"}>} Occurrence_Client)
What does it show in the chart? Image? Better still, can you share a sample?
here is a lighter version of the model. It's weird the calculation is unstable when I open the number of clients that meet the criteria is 2 and when I click on a client it goes to 4
thank you for your help
!