Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i should reply this formatting rule in my pixel perfect table. Any suggest?
thank you all
if(
(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3)
> above(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3) and
above(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3)
> above(above(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3)) or
(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3) > (Max("Valore Rif con RIT TDG")* 100000) and
above(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3) > (Max("Valore Rif con RIT TDG")* 100000), red(),
if((if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3)
> above(if(Sum(Consistenza) = 0, 0, ((Sum([Numero Avarie con RIT])/Sum(Consistenza))/2190) *100000)*3)
, Yellow()))
create a column in you source table which will return values in column (red, yellow...). Then bring that collumn to the detailed report (you may hide it as well so it is not visible on the report but it needs to be present in that detailed report) and based on the value it returns use pixel perfect conditional formats which would be as straight forward as the one mentioned here:
https://www.youtube.com/watch?v=CEXDTVKSoos
create a column in you source table which will return values in column (red, yellow...). Then bring that collumn to the detailed report (you may hide it as well so it is not visible on the report but it needs to be present in that detailed report) and based on the value it returns use pixel perfect conditional formats which would be as straight forward as the one mentioned here:
https://www.youtube.com/watch?v=CEXDTVKSoos