Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Does data type should be same in set analysis?
Example:
SUM({<oderdate={'<=201712'}>}Sales)
oderdate is in text format and 201712 is in date format.
The above one is not working.Kindly help
Thanks & Regadrs,
Dinesh M
Hi,
Yes it should be same.
Regards,
Kaushik Solanki
Try to put it btwn doubles quotes as a first test.
orderdate is text format? If that is true this may not work... but are you sure it is text? may be it is a number?
May be try this
SUM({<oderdate={"=(date#(oderdate,'YYYYMM')<=DATE#(201712,'YYYYMM'))'}>}Sales)
Hi Sunny,
Yes, orderdate is in text format.