Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am Using the following Expression:
=Sum({<[Revenue.Invoice Date] = {$(vCutoffDate)}>} [Revenue.Invoice Amount]/vMillion)
Its returning me an Error: ERROR in SET MODIFIER, ',' or ')' Expected.
Need Help..
Hello GUys Please Help,
Its Ugent,
=$(vCutoffDate) in a text box, is giving me -20, but =vCutoffDate in a text Box is giving me '02-11-11' which is correct. I guess there is the problem.
But I am using the same variable to calculate >=Start Date to < CutoffDate which is working fine,
Also used it in >CutoffDate to <=EndDate which is also working fine,
Only = CutoffDate is not working.
Hi,
Can you share sample application to look over.
Regards
ASHFAQ
Try this: {'$(=Date(vCutOffDate))'}...
Hi Alkesh,
In your variable module where you have declared the variable, add a = in the begining of the variable declaration
ed:
=Max(Year) instead of max(Year)
Regards
KC
This Variable is entered by the user through an Calender Object.
I already changed the number format in the calender object as Date 'DD-MM-YYYY'
That Would be a little Difficult..Sorry!
NO, The answer is still 0,
It is difficult to tell without seeing.
Contact me on skype
my skypeID: ashfaqhaseeb
Regards
ASHFAQ
But you have 'DD-MM-YY' in your variable you says.
I am in Office, Can't connect now...:(