Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use Expression Background color (Expressions Tab) is more flexible than Visual Cues
Use Expression Background color (Expressions Tab) is more flexible than Visual Cues
yeah, that worked in an instant....
Just have to know your colour codes.
Thanks a bunch