Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
c_pannese
Partner - Creator
Partner - Creator

Nprinting rules formatting Above function

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()))

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

1 Reply
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.