Has anyone come across a problem trying to use the FieldValue function in the formation
FieldValue('MyVariableExpressions', rowno())
where
LOAD * INLINE [
KPI, MyVariableExpressions
abc, $(veABC)
def, $(veDEF)
];
and, veABC = NUM(SUM({<MTDFlag=1>}Sales), '#,##.0') etc.
I am having the problem where the pivot table I use this in with KPI as the Dimension doesn't do as expected.
Any help would be appreciated.