Looking to use Set Analysis to have a dynamic variable for date field to retrieve yesterday [of the selected day] sales.
my Fields are :
1- TRANSACTION_DATE (For Date)
2- SALES (For Sales)
and I use IF condition for retrieve a specific category of sales already do it.
I tried many statements some them gave Zero values and some Gave me -
kindly help me to find the Solution for that
if this doesn't work
try this , it's important that you'll use exactly the same date format as TRANSACTION_DATE format
thanks Dears lironbaram and Manish,
both of your suggestions are working probably without select a specific date but once i select a date the value will be Zero and I'm sure this field contain value and absolutely not zero
any suggestions from your End about this issue ?