2 Replies Latest reply: Dec 3, 2015 9:01 AM by Simon Brulotte RSS

    Expression background color vs Custom cell format

    Simon Brulotte

      Hi,

      I have an expression background formula that basically says if you're under budget by 250K and that is 10% of budget then put in lightgreen, if false but you're over budget by 50K and that is 10% of budget then you're in a red color.

       

      see this:

      =if((sum({$<[%CLE_Type_Transaction_ID] -= {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)-

      sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)> 250000) and

      (sum({$<[%CLE_Type_Transaction_ID] -= {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)-

      sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)>

      0.1*(sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * %CR004M))),lightgreen(),

       

       

      if((sum({$<[%CLE_Type_Transaction_ID] -= {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)-

      sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)< -50000) and

      (sum({$<[%CLE_Type_Transaction_ID] -= {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)-

      sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * -1)<

      -0.1*(sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * %CR004M))), RGB(255,87,129)))

       

       

       

      Works like a charm for all my rows except the last total line. It just free games on me

       

      Sans titre.png

       

      I try to fix the background color with a custom cell format, but the expression background color takes precedence.

       

      Any clue why this would happen?