Skip to Content
0

Webi formula for prior and future

Oct 25, 2017 at 11:22 AM

26

avatar image
Former Member

Hi Experts,

This following formula already implemented in Crystal Reports, we would like to now we need to Implement in Webi.

if datevalue({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}) < datadate - 60 then 'PRIOR'
else if {DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE} > datadate + 60 then 'FUTURE'
else totext(datevalue({DAILY_ORDERS_BY_ENTRY_DATE_ST.FORECAST_DATE}))

How to do use this formula in Webi.

Thanks in Advance Experts, this is little urgent pls give me solution on this.

Regards,

Bharathi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Oct 25, 2017 at 11:57 AM
1

Hi Amit Kumar,

It's working fine, Thank you so much for your help.

If you don;t mine please provide me your Mail id, very thankful for your help.

Regards,

Bharathi.

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Oct 25, 2017 at 11:30 AM
0

not very sure about the crsytal report formula.assuming datadate function in crystal is the date on which report was refreshed.you can try with below formula.

=if([Your date object]<RelativeDate(LastExecutionDate();-60)) then "PRIOR" elseif(Your date object>RelativeDate(LastExecutionDate();60)) then "Future" else [Your date object]

Share
10 |10000 characters needed characters left characters exceeded