Is it true that you can't tier IIf conditions in Access? This has to be in a report, because it is based on a RunningSum calculation.
Expression I'm trying is below - should be pretty apparent on what I'm trying to do. Any suggestions? Anything that is not .5> is showing up as "CoreB". The other two cases (NonCoreA and NonCoreB)aren't registering.
=IIf(0.5>[% of Total],"CoreA",IIf(0.5<[% of Total]<0.7,"CoreB",IIf(0.7<[% of Total]<0.85,"NonCoreA","NonCoreB")))
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!