TM1 Forum

Hi - new to TM1 and I am attempting to create a cube calculation unfortunately the attempt has failed.

I have added a text member to my Price_and_Cost_Measures dimension to indicate if a product type is unprofitable. This seems fine, however the cube calculation I have created has failed, as I have tested it with figures that are unprofitable, however "Unprofitable" does not appear in my Product Status text member as I would like it to.

Please refer to the screenshot and thank you in advance for your help.

I may be missing something but your rule requires "Unit Cost" and "Unit Sale Price" to BOTH not be zero in order to show "unprofitable" (in addition to a negative profit) but in the screenshot every "Unit Sale Price" is zero... therefore I wouldn't expect any cell to show "unprofitable".

ah...so sorry I see this now. Thank you so much for your help!

best