I do have a follow-up question. I am in the process of converting my expressions and ran into a issue that I dont understand. When I put the following code (see below) into a variable and reference it in an expression, it shows up. However, if I put it in the code block as discussed above, it errors out. I did make sure I put the Measure dimension into the Aggr.
However, if I embed the calculation directly into the If script (as described above) it works.
If I embed this calculation (wth the variables) it returns the correct value. If I embed this into a variable (varPaidFTEs), It yields a null value. However, if I create another expression and reference it, it brings back the same value for all columns. When I saw this, I thought it was due to the variables it was referencing (varAvgDailyCensus, varPaidHourPerstat, etc), so I embedded those calcs into varPaidFTEs.
Still trying to grasp the logic engine in Qlikview!