Issue in Set Analysis

[#1]

Dear Team,

i want to compare Clientwise Sum(orders) - Sum(orders) of MIN Date.

for getting Orders of MIN Date i am using logic as below:

Created a Variable :

vMinOrderDate=min(ORDER_DATE)

then using below mention set analysis

SUM( {<ORDER_DATE={$(vMinOrderDate)}>} ORDERS)

Please let me know what wrong i am doing

[PrashantSangle · Accepted solution]

Hi,

Try this,

with ""

like

SUM( {<ORDER_DATE={"$(vMinOrderDate)"}>} ORDERS)

Regards

[alexandros17]

According to me, vMinOrderDate=min(ORDER_DATE) return the date in numerical represenatation so you are comparing a date to a number.

try with

vMinOrderDate=Date(min(ORDER_DATE))

let me know

[#4]

I understand what mistake i was doing i was missing ' ' single quote Below mention is working now .. SUM( {} ORDERS)

[#5]

Hi,

Keep '' wen you are using the variable in set analysis

SUM( {<ORDER_DATE={'$(vMinOrderDate)'}>} ORDERS) (or)

SUM( {<ORDER_DATE={"$(vMinOrderDate)"}>} ORDERS)

[aveeeeeee7en]

Hi Jitendra

Try this Expression:

SUM({<ORDER_DATE={'$(=MIN(ORDER_DATE))'}>}ORDERS)

Regards

Av7eN