Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello... Need your help!!!
Maybe this is a stupid question, but I´ve tried hard, and cannot make this work...
I´m using this expression to give MTD values:
Sum( $(vSetMTD) MyField)
But I need to exclude something from values, so I´m trying to use Set Analysis, like:
{$<Category-={'FieldName'}>}
Where do I insert this Set analysis???
I´ve tried before variable, after variable... and nothing... It just ignores the set analysis!
Thank you all!
Best Regards,
BS.
Thank you all for trying to help.
Like I´ve said it above, vSetMTD is a variable that allows me Month to Date Analysis! The expression in this variable is in fact a Set Analysis. So what I did was to replicate it, and exclude what I need there, so my expression remains the same.
Sum( $(vSetMTD) MyField)
Thanks!
Problem Solved!
what is?
$(vSetMTD)
Hello BS,
Go through PDF, this may help you.
Thanks & Regards,
Upendra
In fact is a Set Analysis in a variable.
I will try now to replicate the variable and make the exclusion inside the variable expression!
Not sure what your variable is doing, but the set analysis would go inside the expression. Something like as follows.
Sum({$<Category-={'FieldName'}>} $(vSetMTD) MyField)
Try
Sum ({<Field1-={‘A’}>}Sales)
will sum all Sales except from field1 : 'A'.
Thanks...
Already had it, but thanks anyway!
Thank you all for trying to help.
Like I´ve said it above, vSetMTD is a variable that allows me Month to Date Analysis! The expression in this variable is in fact a Set Analysis. So what I did was to replicate it, and exclude what I need there, so my expression remains the same.
Sum( $(vSetMTD) MyField)
Thanks!
Problem Solved!