Sorry it was C1! My Dimension order is:
The calc is set to "0" - this should be fine as the Account is mapped before C1, correct?
I am importing data from SQL Table and don't have anything coming into C1.
On C1 my Like has
If left(HFMAcc,1) = "1" Then
Result = "F99"