Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try this =Replace(Field,CHR(39),'')
See the sample attached file also.
HTH and let me know.
Regards,
Sokkorn Cheav
But in your example does not return the results
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
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.