TM1 Forum

Hi Sorry for the confusion The requirement is Let me elaborate my requirement "Lease Id" "Lease Name" "Area" "Cost Type" "Cost" " 1 " "ABC" "10 sq" "C1" "100" " 1 " "ABC" "10 ...

Hi Paul, Thank you for the reply we can make area as measure as we need to calculate total area of a region with total amount. We can't have sum of area as it duplicates . Please let me know if there are any rules that we can make area non aggregate and amount as aggregate or load precalculated valu...

Hi I have a scenario Region Property_Status Lease_ID Building_Sublet_Area SubLet_Area Gross_Area Calendar_Year Currency_from_CD Cost_Type Net_Amount Gross_Amount Sublet_Amount Sublet Asia Active 123 10,000 10,000 2016 USD OPERATING 1,000. 1,000. Asia Active 123 10,000 10,000 2016 USD ELECTRICITY 2,0...