3 Replies Latest reply: Apr 3, 2018 4:37 PM by Petter Skjolden RSS

    If expressions results in "invalid dimension' - any hints?

    Rebecca Kutz

      =If((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))<=1.0 and (Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))>=0.5,'H',

      If((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))<0.5 and (Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))>=0.25,'M',

      If((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))<0.25 and (Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted]))/((Sum({<[Win/Lost] ={Won}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Lost}>}[Estimated Oi UnWeighted])+Sum({<[Win/Lost] ={Cancel}>}[Estimated Oi UnWeighted])))>=0,'L',

      '0')))