I have loaded and inline statement which allows me to do a mapping load and align a target to a metric
Inline
Target:
MAPPING LOAD * INLINE [
Metric, Target_Line
A, 3
B, 0
C, 0
D, 2
E, 0.97
];
The mapping load is then applied to a table in my load and results in a field called Safe_Target
I now need to reference the Safe_Target field in order to show under Text Color of an expression as to whether the Metric has hit the target of not. However some of my metrics have a target of >= or <= and some of my metrics are counts, while others are %'s.
My problem is I cannot get the text format to show for each Metric accurately. This is my attempt at trying to apply a Target_Line with lots of different combinations. Only Metric A and D are showing accurately so far
-------
If(Num(sum({$<Metric = {'A', 'D}>}Numerator))
<=Num#(Safe_Target), $(vColour_Green),
-------
If(Num(sum({$<Metric = {'B', 'C'}>}Numerator))
>Num#(Safe_Target), $(vColour_Green),
$(vColour_Fail_Target)
Can anyone provide any advice as to how I can get Metrics B and C to also show the correct text colours. I understand that my expression may not have been written accurately
