StorageScope 6.0 Calculated columns

Question

I have created a calculated column in StorageScope 6.0 to convert from KB to GB. Now I would like to use the newly created column to create another calculation for chargeback, however the columns I created do not show up under 'Manage Calculated Columns.' Is there a way to reference a column I created in another calculation?

seth_silverman · Accepted Answer

You cannot create a new calculated column based on an existing calculated column.

BarryR1 · Answer

What you can do instead is use the previously created custom column as a starting point for this new custom column.

In Manage Calculated columns window,
-select the calculated column you created previously

-this will cause the expression window to be populated with the expression that
this column is based on

-check the "create a new column" checkbox and give it a meaningful name and add the chargeback calculation to the expression window.

You will then need to Save your work as usual.

HeatherM1 · Answer

I've tried doing that but it doesn't allow more than one division in an expression....

Allen Ward · Answer

I haven't tried this yet myself, but if you can truly only have one division in an expression you could always "cheat" it by multiplying instead...

instead of 'x / 2' you would use 'x * .5'

This might help.

HeatherM1 · Answer

Can't use decimals either...These seem like pretty ridiculous limitations, has this been changed in 6.1?

Allen Ward · Answer

No, this has not been fixed. I just tried both, and neither option worked.Must be time to submit an 'enhancement request'... (otherwise known as a 'bug fix' request *lol*)

Storage Resource Management (SRM Suite)

StorageScope 6.0 Calculated columns

Was this post helpful?