D/ALL
I have all but finished a project till this multiple conditions for a
sale_amount expression came up.
'saleamt' expression in a query has many conditions based on three fields.
For example:
1. field1: two types of products: 'itemA' or 'itemB'
2. field2: two types of sale: 'free' or 'sale'
3. field3: three category: 'owner' or 'agents' or 'staff'
4. if itemB is given 'free' to 'staff' then saleamt = 0 ( price * qty *
0(zero))
5. if itemB is given as 'sale' to 'staff' then saleamt = price * qty
6. if itemA is given to owner and agents then saleamt = price * qty
7. if itemA is sold to 'staff' then saleamt = price * qty plus 10%
BB) The sum of sale amount not to include the item-4 ( if given free not to
add this amount)
Just to frame this thread itself took enormous time to explain it in short.
Month end is fast approaching and I have to figure out a way to do this, failing which the last 45 days efforts will go waste as this program can not be used.
Will be very eagerly waiting for guidance and help. Pls oblige.
brgds/captgnvr
I have all but finished a project till this multiple conditions for a
sale_amount expression came up.
'saleamt' expression in a query has many conditions based on three fields.
For example:
1. field1: two types of products: 'itemA' or 'itemB'
2. field2: two types of sale: 'free' or 'sale'
3. field3: three category: 'owner' or 'agents' or 'staff'
4. if itemB is given 'free' to 'staff' then saleamt = 0 ( price * qty *
0(zero))
5. if itemB is given as 'sale' to 'staff' then saleamt = price * qty
6. if itemA is given to owner and agents then saleamt = price * qty
7. if itemA is sold to 'staff' then saleamt = price * qty plus 10%
BB) The sum of sale amount not to include the item-4 ( if given free not to
add this amount)
Just to frame this thread itself took enormous time to explain it in short.
Month end is fast approaching and I have to figure out a way to do this, failing which the last 45 days efforts will go waste as this program can not be used.
Will be very eagerly waiting for guidance and help. Pls oblige.
brgds/captgnvr