
1. Re: Hi Team,
Shinichiro Murakami Nov 11, 2016 5:43 PM (in response to Archana Sharma)Archana,
First of all, I recommend that you change the table structure with pivoting the data.
Original file.
Data source edit and Pivot data
Create same Table.
Then three(?) steps.
Calculate Min and Max for respective "Customer" in this example.
[Max Data]
{fixed [Customer]:max([Pivot field values])}
[Min Data]
{fixed [Customer]:min([Pivot field values])}
Determine which data is correct ( assuming three numbers is correct and one number is incorrect)
[Positive or Negative]
{fixed [Customer]:count(if [Pivot field values] = [Max data] then [Pivot field names] end)}
{fixed [Customer]:count(if [Pivot field values] = [Min data]then [Pivot field names] end)}
[Base Score]
if [Positive or Negative]>0 then [Max data] else [Min data] end
Color the incorrect cell.
[Delta Cell Color ]
if [Pivot field values]<>[Base Score] then "NG" else "OK" end
Thanks,
Shin