
Anonymous
Not applicable
2012-08-07
10:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
class with aggr function boundaries
I have table with calculated dimension using class and aggr functions
The result looks something like this
To obtain this I forced all days lower than -30 in the "-30 <= Days <0" bucket and averything larger than 150 Days in the
"150 <= Days < 180" bucket
So what I really want to display for the first and the last row is
"Days < 0" instead of "-30 <= Days < 0" and
"150 <= Days" instead of "150 <= Days < 180"
The calculated dimension expression is
=
class(
aggr(if(Sum(Stock) < 0, -1, if(Sum(Stock)/sum(OutGoing*-1)>150,155,
round(Sum(Stock)/sum(OutGoing*-1)))),
Product,Warehouse
),
30, 'Days', -30)
Can anyone tell me how to do this
1,071 Views
0 Replies
