Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to count all customers who have been customers since this year. The date field "S_Custom.Custom_since" is available for this.
In addition, the condition "S_Custom.ypA_NK_BST = {1}" must be met.
I've been trying all the time to find the right formula to only display the customers for the current or selected year. Unfortunately without success.
Do you have a tip for me?
Count({<Year(S_Custom.Custom_since)={current year/selectet year}, S_Custom.ypA_NK_BST = {1}>}distinct [S_Custom.Custom])
Hello,
I think you must create a field Year(S_Custom.Custom_since) ASS_Custom.Custom_since_year in the script
then use this :
Count({<S_Custom.Custom_since_year={$(=Max(Year))}, S_Custom.ypA_NK_BST = {1}>}distinct [S_Custom.Custom])
Regards,
Régis