Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, everyone-
I am trying to change the background color to a column in a table, I have it working for two colors using this expression:
Count(Distinct [Inspection Bar Code])/$(fInventoryCount]<.50, RED(), Yellow()
But I want to add also if it's over .70 to be blue and if it = 0 to be black. Yet everytime i try to add to the expression it stops working.
Any ideas?
Thanks!
Try this:
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount) = 0, Black(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount)<.50, RED(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount)< .70, Yellow(), Blue())))
See the attached app
can you share your QVF file containing this table?
Thanks
May be you missed the if statement?
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount]<.50, RED(), Yellow())
I have the "If" in it, sorry I didn't include that in my question!
I just attached it to my original post. Thanks!
Then try this
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount] = 0, Black(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount] <.50, RED(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount] < .70, Yellow(), Blue())))
That's what I thought it would be and it's not working. So strange!
Try this:
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount) = 0, Black(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount)<.50, RED(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount)< .70, Yellow(), Blue())))
See the attached app
It's working, It's just that sunny miss wrote it
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount] = 0, Black(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount] <.50, RED(),
If(Count(Distinct [Inspection Bar Code])/$(fInventoryCount] < .70, Yellow(), Blue())))
$(fInventoryCount) not $(fInventoryCount]
Ah! What a foolish mistake!! THANK YOU!!!!!