Skip to Content
avatar image
Former Member

Webi formula for prior and future

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2017 at 11:30 AM

    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]

    Add comment
    10|10000 characters needed characters exceeded