Not applicable
2010-01-29
04:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Does set analysis work when calling a variable with dollar sign expansion?
The following is my variable definition:
PrintX
if($1>0.9,'X',$1)
When using expression A PrintX produces the correct result but with expression B it does not work.
ie A gives a list of numbers except for numbers larger than 0.9 where it writes an X.
Expression B gives null results.
Expression C gives correct decimal numbers.
A = $(PrintX(0.01* Count( distinct SalesID )))
B =$(PrintX(Count( {$ < Status={"B","G","V"} >}
distinct SalesID) /
Count(distinct SalesID)))
C =Count( {$ < Status={"B","G","V"} >} distinct SalesID)
/
Count(distinct SalesID)
Maybe there is another way to write a character for ranges of numbers rather than using a $ sign expansion or am I doing something wrong in expression B?
353 Views
0 Replies