3 Replies Latest reply on Jan 24, 2018 12:22 PM by Shinichiro Murakami

# Work Around for Level of detail expressions cannot contain table calculations or the attr function

Hello Guys,

Im trying to figure a solutions for Table Calculations. but i was getting a error when i was trying to use one table Calculations field in another table calculation field "Level of detail expressions cannot contain table calculations or the attr function"

Below is the Calculations

[Total Goal] =

countd(Customer Number) * (1/ ([Company Univ Non X (Market)] / (if [Company Univ] = 0

THEN [Company Univ Non X (Market)] else [Company Univ] end )))

[Company Universe Non X (Market)] = total(sum({ FIXED [Market] : MAX([nonX_mktUE])}))

[Company Universe] = total(sum({ FIXED [Market] : MAX([Company UE])}))

Now im trying to use this Table Calculated [Total Goal] in new [New Total Goal] Formula is {Fixed [Nwtrk] : [Total Goal] }

But im getting the error "Level of detail expressions cannot contain table calculations or the attr function" can some one please help me

Thanks

• ###### 1. Re: Work Around for Level of detail expressions cannot contain table calculations or the attr function

Could you please attach packaged workbook for us to support you more easily.

Thanks,

Shin

• ###### 2. Re: Work Around for Level of detail expressions cannot contain table calculations or the attr function

Sorry Shinichiro Murakami it was live Dashboard with 4 billions rows in that have replicated a same one with sample data appreciate your help

• ###### 3. Re: Work Around for Level of detail expressions cannot contain table calculations or the attr function

I am still struggling to understand your expecting logic, but focusing on removing errors, is this number correct?

If not I want to know your expecting numbers for my better understanding.

Thanks,

Shin