Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attached please find the Straight Table. I am using the Class Function to Do my intervals. The intervals are for the Dimenion "Score". The Max Score is 100.
I am good every where Except when it comes to the Interval of >=95 and <100 (127) and >100 <105 (68), I want the the (68) to be a Part of >=95 and <100 so the Correct Total should be (127+68). How can I accomplish that
Provide sample data please....
For such requirement, you need to use If function rather than Class....due to having different range...
Rehan
Are you saying that the max score is 100? If so where do the scores come from that are above 100?
I would create a sort order on your class dimension to clean up the display.
Can you create a Text object to display =max(Score) ? and verify the data?
It may be helpful if you could post an example?
Richard