Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This variable is working: $(CM)
But when putting it in a Set Analysis it doesn't:
sum
({$<InvoiceYear={$(=Only(InvoiceYear)-1)}
,
InvoiceMonth={"<=$(=max(InvoiceMonth))"}
>}
$(CM))
The result is "-"
I have also tried to take the formula from the variable (which is 2 other variables) and copied this in instead of the $(CM) - No result.
Thanks in advance for your help
Hi John,
Set analysis doesn't apply to variables - any more than Sum, Avg, Count do!
Your variable will have a value - e.g. CM = 5. A sum statement like this:
Sum(CM) or Sum($(CM)) {both are equivalent}
is actually saying:
Sum(5)
It doesn't make any sense.
Regards,
Stephen
Instead of using a variable you should be able to use a field containing the name of the field to summarize.
i.e. you have a field called MyFieldName where the value is MyField ok ?
Then in your expression you put SUM({$<InvoiceYear={$(=Only(InvoiceYear_1)},InvoiceMonth={"<=$(=max(InvoiceMonth))"}>} $(=only(MyFieldName))).
This will work ( in this case I advise that you mandatory always one value selected for the field MyFieldName.
Rgds,
Sébastien
What is the definition of your variable? You said it was made up of other variables, could you post the definitions of those.
You can use a variable in the context you describe. If your variable contains an expression, then that expression would be evaluated as part of the Sum.
Also, have you tried removing the Set Analysis portion to see if that is at fault? If your expression works, Sum($(CM)) should give results.