Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to create an expression which is restricted to only sum when the calendar day in my data table equals the variable I have set via the load script called vLatestDay, however this is not working. Here is what I have in the expression:
Calendar day = Date dimension
vLatestDay = Variable date
WH Stock = The value I am trying to sum
Expression:
Sum({$<[Calendar day]={'>=$(=vLatestDay)'}> } [WH Stock])
Can you please let me know if the syntax for the expression is OK? It does not seem to give me the expected result
Thanks,
R
Hi Riley,
Try,
Sum({$<[Calendar day]={">=$(=vLatestDay)"}> } [WH Stock])
or
Sum({$<[Calendar day]={">=$(vLatestDay)"}> } [WH Stock])
Make sure date format for the field Calendar day and variable vCurrentMonth should match.
Expression looks ok. what is the expression for vLatestDay?
Expression looks okay, just bypass the Date Field, make sure Format should be common throughout..
try this:
=Sum({$<DateField= ,[Calendar day]={'>=$(=vLatestDay)'}> } [WH Stock])
Hi,
first, you use a single quote, you should use a double qoute.
What is the value of vLatestDay, is it a value or a expression? Try to remove the equal sign.
Is vLatestDay in the correct format?
Regards
Sebastian Lettner