Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
the sign "-" Shows that something is wrong.
how does your Expression Looks like. please Show it
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
HI,
In your difference Expression, write below code.
=column(1)-column(2)
Regards
ASHFAQ
please post example qvw.
maybe there is more than one combination of your subtracted values for a givden dimension combination.
regards
Marco
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
The two fields comes from diffirent tables.
Can i write a code like resident load where I can take the difference between two fields
depending of the relation between your tables there might be more than one combination. So you might need an aggregation (sum, min, max, ...)
Hi Pavan,
Try this expression using your expression captions
=[SISEpremium] - [OGIS premium]
Regards,
Jagan.