Topic Options
#24742 - 06/09/10 01:45 PM How do I multiply
Jpizzle Offline
OL Newbie

Registered: 02/12/10
Posts: 9
Loc: USA
I am given a number in an Excel spreadsheet that represents a dollar amount. I am being asked to multiply by 1.5 for one amount and by 2 for another.

How do I do this.

Thanks in advance for your help.

Top
#24743 - 06/25/10 04:33 PM Re: How do I multiply
Anonymous
Unregistered


Hi,

Assuming the number is given in an Excel Field named 'Test', a PSM expression displaying the double of this amount could look like:

Code:
STR(VAL([Test])*2)
i.e. convert [test] into a number (with VAL), then multiply it by 2 (with *), then reconvert the result back into a string (with STR) so that it can be displayed on the page.

Hope this helps!

Benoit

Top