Visual cues: does it take set analysis?

[sibrulotte]

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?

[Clever_Anjos · Accepted solution]

Use Expression Background color (Expressions Tab) is more flexible than Visual Cues

[sibrulotte]

yeah, that worked in an instant....

Just have to know your colour codes.

Thanks a bunch