I thought this would be much simpler than it has turned out to be. Two columns of numbers, each from a different powerpivot table. If one is less than the other, than "Possible", otherwise "" (blank). Maybe a different statement is necessary to achieve the desired result?????
One of dozens of variations I've tried:
Violation22:=if([IIS Name Count]>Licenses[Allowed Servers],"Possible","")
The IIS Name Count field is in a separate table and can have multiple rows with the same IIS name that will be summed to compare against the Allowed servers which is the max # of IIS Names that can exist.
Any insight is SO greatly appreciated.
One of dozens of variations I've tried:
Violation22:=if([IIS Name Count]>Licenses[Allowed Servers],"Possible","")
The IIS Name Count field is in a separate table and can have multiple rows with the same IIS name that will be summed to compare against the Allowed servers which is the max # of IIS Names that can exist.
Any insight is SO greatly appreciated.