Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everyone,
I am trying to assign an Pick_match expression in the format paremeters in the num function. This expression is assigned to a variable called vFormat and it gives a format of M (millions), k, (thousands) or normal. The variable vDivision assigns a value of 1,1000 or 1000000 depending on the case.
The problems is this expression works correctly like this:
NUM(Sum(Measure)/$(vDivision),PICK(MATCH($(vDivision),1000000,1000,1),'#,###.## M','#,###.## k',''))
But not with this format:
NUM(Sum(Measure)/$(vDivision),'$(=$(vFormat))')
NOR $(vFormat), '$(vFormat)',$(=$(vFormat)),'$(=$(vFormat))'
I attach also a qvf file with the example
Thanks in advance for your invaluable support.
P.S. The variables must be defined on a qvs file/script.