Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all!
Do you know if can I have something like this:
Count({<Product=[100,...,322]>}Sales)
Instead of describing all of my products between 100 and 322...?
Thank you!
May be this
Count({<Product = {'>=100<=322'}>}Sales)
Thank you,
In fact, what I have is a code for the current week of the year (different from the usual number). I want to analyze from week 1 to the one we are in now so I needed something like this:
AllocWeekYear={'>=1 <= 'Only({<AllocDate={'$(=Date(Today(),'DD-MM-YYYY'))'}>}AllocWeekYear)''}
but it's not working... do you have any idea what i might be doing wrong?
May be this
AllocWeekYear={">=1<=$(=Only({<AllocDate={'$(=Date(Today(),''DD-MM-YYYY''))'}>} AllocWeekYear)''}
Like that AllocWeekYear and AllocDate aren't recognized as fields and only, date an today as functions
Would you be able to share a sample?
I can not for confidential reasons.. Thank you
ok
If I use this:
AllocWeekYear={">=1<=45"}, the expressions works well.
If I use this, AllocWeekYear={">=1<=($(vCurrentAllocWeek))"}, where vCurrentAllocWeek it's a variable =max({<AllocDate={'$(=Date(Today(1),'DD-MM-YYYY'))'}>}AllocWeekYear), the expressions doesn't work..
That's everything I can share... do you have any idea what might be the problem?
May be try to add an equal sign before your variable
AllocWeekYear={">=1<=($(=vCurrentAllocWeek))"}
or this
AllocWeekYear={">=1<=($(=$(vCurrentAllocWeek)))"}