Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Approval No_9digit is extracted from Approval No.
If the Approval No_9digit is same and repeating, need to highlight the entire row
Attached screenshot
Hi,
You can try using If & Previous.
If(ApprovalNo_9digit = Previous(ApprovalNo_9digit), Yellow())
(Sort data on DepotDate)
Thanks,
Ashutosh
this didn't work
maybe this expression:
if(count( Total <[Approval No_9digit]> [Approval No_9digit]) > 1 , LightGreen())
or
Aggr(NODISTINCT If(count([Approval No_9digit]) > 1, LightGreen()), [Approval No_9digit])
this didnt help