ruby in calculation string

Hi, I'm trying to have a report according to my needs.

I've an attribute named dc: um that's coming from the seed component. Is a choosing dropdown list: mq, mc, kg, etc..

particularly:

the field cost_tot should be conditioned in this way:

IF dc: um is equal to mq (according with is it choose in the dc list)

THEN cost_tot is = %a-m% * cost_unit (first operator could change for ex in %v-m% if is listed mc .. and so on)

I'm novice both SD both Ruby.

Could yopu help me?

Many thanx

Pier

I link file for analysys.

http://dl.dropbox.com/u/255954/space_design_test.zip

▶ Reply to This

Replies to This Discussion

Permalink Reply by Pier Andrea Orazi on May 6, 2012 at 4:04am

Hi Gregory,
Yes, you are in the right. I think that the problem belongs by text argument (m2, m3, ...) in numeric field. This could be confirmed by the fact that if you substitute m2 with 1, 2, etc. the Ruby seems to do his job.
Only Al, I think, could dig inside the question.
I'll wait.
All the best
Pier

▶ Reply

Permalink Reply by GTM on May 7, 2012 at 2:51pm

Hi Pier,

Have a look the Ruby operators.

http://www.tutorialspoint.com/ruby/ruby_operators.htm

Based on Al's example and changing the DC 'Value' to 'NUMBERS' (your component uses 'TEXT' in 'Value') where:

- 'm2' is '1'

- 'm3' is '2'

the Ruby works - PAO.pdf report attached

%dc: um% == 2 ? %cost_unit% * %area% : %cost_unit% * %volume%

Probably you have tested the option described above.

The downside is - you cannot get the 'UM' as 'm3', 'm2' on the SD report (or I don't know how to do it)

Regards

Gregory

Attachments:

PAO.pdf, 162 KB

▶ Reply

Permalink Reply by GTM on May 7, 2012 at 3:12pm

Hi Pier,

I can see that you have tested the option already.

I typed my post yesterday and I paste it Today :) amended online but it took me more than 10 minutes and my time for changes was up !

Regards

Gregory

▶ Reply

Permalink Reply by Pier Andrea Orazi on May 7, 2012 at 3:20pm

Hi Greg,
I cannot test now, 'cause I'm going to sleep (italian time)
Tomorrow morning I will upload something on which I'm working on...
Hedache!
Ciao
Pier