Conditional Formatting on Repeating Field
I have a repeating calculation (number) field with 7 repetitions in a table (Timesheet::Daily Total), and a single number field in another table (Insured::Budget).
Using conditional formatting, I want any one of the Daily Total repetitions to display red when that repetition exceeds the value in Budget (but not all repetitions, only the one that exceeds).
Conditional Format on Timesheet::Daily Total
Value isgreater than Insured::Budget
It doesn't work.
If I set Value isless than, ALL repetitions turn red no matter what the value of Timesheet::Daily Total.