Quick Question

[jadams123]

Hi All:

Question 1:

I want too:

if (today -1) = mon then 0, if (today -1) = tue then 2, if (today -1) = wed then 3...and so on

Question 2:

I want to be able to do this:

How can I group:

1) Group anything other than CX1, CX2, CX3, CX4 in "Other CX type East"

2) Group anything other than CX5, CX6, CX7, CX8 in "Other CX type West"

and so on...

Group	Customer Type	Sales
EAST	CX1	$100.00
EAST	CX2	$200.00
EAST	CX3	$300.00
EAST	CX4	$400.00
EAST	Other CX Type EAST	$500.00
Total EAST		$1,500.00
WEST	CX5	$600.00
WEST	CX6	$700.00
WEST	CX7	$800.00
WEST	CX8	$900.00
EAST	Other CX Type WEST	$500.00
Total West		$3,500.00

This is my current formula. This obviously just shows sales for CX's

= Sum( {$<GLYEAR = {2017},

CUSTOMER_TYPE = { CX1, CX2, CX3, CX4, CX5, CX7, CX8 },

CREDIT_CODE = {YES}>} AMOUNT )

Thanks,

J

[jadams123]

its a database.

[vishsaggi]

Can you run your database query and attach your qvw file where you have the problem?

[jadams123]

I think this was getting too complicated.

I figured it out.

I created a calculated dim...if(customer type =XYZ, then .... elseif  'Other Customer Type'.

Instead of Other Customer Type east/west e.tc

[vishsaggi]

IF it solved your query, please close the thread marking correct or helpful to which ever responses you feel helped you.