0

# Formula in Webi From Date

Nov 01, 2017 at 04:01 PM

36

Former Member

Hi,

Need help to solve the . i need all in date format

1) Last date of the year from any given date

2) Add 11 month from any given date

AMIT KUMAR
Nov 01, 2017 at 04:36 PM
0

Last date of the year=RelativeDate(ToDate("31/12/"+FormatDate(([Your date object]);"yyyy");"dd/MM/yyyy");-1;YearPeriod)

Share
Former Member Nov 01, 2017 at 05:04 PM
0

Hi Both,

Thanks much working fine.

I have another issue

I have 2 data providers Q1 contain Material and Q2 contains ISBN. I am merging both at report level.

(Material and ISBN is list of numbers and both are string)

eg

Material ISBN Formula

111 111 A

121 122 B

123 124 C

Now I want to write a formula based on that saying that

if (Material =ISBN Then “A” (Eg:111)) ElseIf (if the number only in Material then “B”(eg. 121,123) Else (IF the number only in ISBN then “C”(eg.122,124 )))

Show 3 Share
Former Member

Hi Sudarsan,

How can you compare same row twice and how you can place the output twice for same row.

it better used

if Material =ISBN Then Material Else Material + ISBN

Regards,

Anish

Former Member

we can match the record by using Material =ISBN (like 111), but what about if the number are in material like (121,123)and not in ISBN (like 123,124 ) and same the other way round.

or do you have any other approach

Former Member

Hi Sudarsan,

I don't have any approach for that. If i found something i will update you.

Regards,

Anish

Former Member Nov 01, 2017 at 04:41 PM
0

Hi Sudarshan,