Calculated Measure

[spicysudhi]

All,

I trying to create a calulated measure and i want the output to be rounded to the nearest 10th value. But i am not finding the round function there. how to get this, bcoz my measure needs to be calculated as

round((measure1/measure2),-1)

thanks,
sudhi

 

[GJParker]

Sudhi

create a calculated column instead of calculated measure, rounding functions are then available. Add this into your list of measures.

HTH

Gary Parker
Systems Support Analyst
Manchester, England

 

[spicysudhi]

i already tried that, but no good for my requirement.

say i have data like this

country state sales forecast
UK S1 10 10
UK S2 10 5
US S1 10 20

I need a measure that calculates the sales/forecast. If i create a calulated column and add that to measure the values at the country level is not correct (i want it to be the sum(sales)/sum(forecast), but it gives sum(sales/forecast) from the states level )

is it clear?????

ofcourse u may suggest me to change the rollup method which is not available if it is not a calculated measure.

regards,
sudhi

 

[spicysudhi]

anyone help me here please...

regards,
sudhi

 

[Draoued]

What if you just play with the Output format and the display of the measure ??
Then the cube will round it itself.

 

[spicysudhi]

actually i need to more than that. First i need to round that to nearest 10th degit and then if the value is more/less than a limit then keep it as the limit.

i tried with display format, but it can remove the decimal places, but no option i found to make it sharp to nearest 10th.

is there anyway to write some additional scripts or something to make it happen? If any way of macro anyone suggesting, please take me thru how to do that. unfortunatelly i never got a change to try macros in cubes.

thanks and regards,
sudhi