Not able to display diffirence

[#1]

Hi Friends,

I am trying to take the difference of tow numbers in a straight table. I am getting errors.

Please see the attachment. Also I want to display the diffirence in premiums as a list box.

Please help

[Anonymous]

the sign "-" Shows that something is wrong.

how does your Expression Looks like. please Show it

[#3]

can u provide what are those two numbers

if these are the two numbers then u can do diference like this

SISEpremium - OGIS premium in the expression part of Straight table

[ashfaq_haseeb]

HI,

In your difference Expression, write below code.

=column(1)-column(2)

Regards

ASHFAQ

[MarcoWedel]

please post example qvw.

maybe there is more than one combination of your subtracted values for a givden dimension combination.

regards

Marco

[#6]

Inorder to display teh diffrerence in Listbox

better do the difference between those two fields in the script area and name it as Premium

and use that premiun as  listbox

[#7]

The two fields comes from diffirent tables.

Can i write a code like resident load where I can take the difference between two fields

[MarcoWedel]

depending of the relation between your tables there might be more than one combination. So you might need an aggregation (sum, min, max, ...)

[jagan]

Hi Pavan,

Try this expression using your expression captions

=[SISEpremium] - [OGIS premium]

Regards,

Jagan.