I have a field with values like "25 X 12". I want to create expression where I multiply these 2 values and get result. For e.g. 25 X 12 = 300
How do I do that?
You can use the transformation in script as:
Num(Subfield(Field,'*',1)) * Num(Subfield(Field,'*',2)) AS Field2.
It will calculate value.
Thanks for your quick reply.
But how can i do it at expression level?
Same expression you can use in Expression.
Can you please explain what should be your output table/chart .
Report should have
Item size will be 300(multiplication of 25 X 12)
Here you can do two things :
1. Create a field ItemSize in Script as I suggested earlier and use that field in you report.
2. You can use expression = (Num(Subfield(Field,'*',1)) * Num(Subfield(Field,'*',2))) in your expression tab.
yes. tried this but not working
This is what I am getting by using the formula in pivote table with help of excel
gr8. Thanks for detailed response. Yes. I got it working...
Retrieving data ...