Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone ,
I have an one date field called Timestamp which contains only data refreshed date (monday date only).
My requirement is, I have to show the trends of data using last 5 monday dates .
This is my expression
if([Key Field]= 'BG, (1-(COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}if(IsNull([BG]), [Opportunity ID]))
/
COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}[Opportunity ID])))*100)
Denominator part is working , i dont know why numerator is not working , suggest any idea to resolve this issue.
Thanks in Advance
Deepak.
Are you missing a single quote after BG?
if([Key Field]= 'BG', (1-(COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}if(IsNull([BG]), [Opportunity ID]))
Are you missing a single quote after BG?
if([Key Field]= 'BG', (1-(COUNT({<TimeStamp={">=$(=Date(max(TimeStamp)-35))<=$(=Date(max(TimeStamp)))"}>}if(IsNull([BG]), [Opportunity ID]))
Deepakraj, did Sunny's reply fix the issue? If so, please be sure to use the Accept as Solution button on his post to give him credit for the help and to let others know this did fix the issue.
Regards,
Brett
Yes this one is working..
Thanks,
Sunny.