Formula in expression in a PivotTable

[#1]

How to convert text such as '2 +2' or '(20 * 5) / 100' on an outcome. But I need to do this from an expression in a PivotTable.

[Sokkorn]

Hi,

Try this =Replace(Field,CHR(39),'')

See the sample attached file also.

HTH and let me know.

Regards,

Sokkorn Cheav

[#3]

But in your example does not return the results

[Sokkorn]

Hi,

Try this once again

[tmp]:
LOAD * INLINE [
ID,TEST
1,''2+2''
2,''5*2''];
[Data]:
LOAD
    ID                                                        AS [ID2],
    Evaluate(Replace(TEST,CHR(39),''))        AS [TEST2]
Resident [tmp];
DROP TABLE [tmp];

Regards,

Sokkorn Cheav

[#5]

In my case, I can do the calculation in the scrip as the operand I have to be calculated based on filters set by the user on another table.