2 Replies Latest reply: Feb 21, 2014 10:18 AM by Simon Brulotte RSS

    Visual cues: does it take set analysis?

    Simon Brulotte

      Hi,

      so in a visual cue, I would like my field ("Écart", which is french for difference, or discrepency) to light up when this condition is respected:

      Above >= 

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

       

      Unfortunatly this doesn't work. I've made a field of that expression just to validate the results make sense, and they do! I get 10% of my budget to show up in a field all lined up next to that discrepency field. But the visual cue doesn't work

       

      What am I doing wrong?