i want subtraction of two expression is the ouput of the expression ? pls see

[#1]

1)   (Vendor
Invoice Value x LBT rate)/100

2)(Vendor
Invoice Value x 2.50)/100. This formula should be applied for the only
following Storage Locations  -  IB01, IB04, IF01, IF02, IF04, IL01, IL02, IN01,
IN02, IN04, ING1, IP01, IP04.

i want write expression   like   1-2  =   my  expression   pls  help  me  ?

[jagan]

Hi,

Try like this

=(Sum(

{<[Storage Locations] -= {

'IB01', 'IB04', 'IF01', 'IF02', 'IF04', 'IL01', 'IL02', 'IN01', 'IN02', 'IN04', 'ING1', 'IP01', 'IP04'}>}

Vendor Invoice Value x LBT rate)/100) - (Sum({<[Storage Locations] = {

'IB01', 'IB04', 'IF01', 'IF02', 'IF04', 'IL01', 'IL02', 'IN01', 'IN02', 'IN04', 'ING1', 'IP01', 'IP04'}>}Vendor Invoice Value x 2.50)/100)

Regards,

jagan.

[Joaquin_Lazaro]

Hi:

If you have two expressions you need the third:

= Column(1) - Column(2)

Joaquín

[#4]

s cexactly  pls  tell me

[Joaquin_Lazaro]

I don't understand your last post

[#6]

see jagan solution  same  i  want

[jagan]

Hi,

Can you attach some sample file?

Regards,

jagan.

[#8]

i need subtraction of those 2  expression   1-2=ouput

[#9]

Hi Manoj,

Can you please attach a sample data file.?

[jagan]

Hi,

If you need the differences between the expressions in the chart as third expression then use this

=Column(1) - Column(2)

Or

=[Expression Label Name 1] - [Expression Label Name 2]

Regards,

Jagan.