1

I am trying to duplicate a detail object from Desktop to its Webi equivalent.

I am familiar with the syntax differences, i.e. using semicolons instead of commas and using [] rather than <> to enclose references to other dimensions/measures/detail objects.

Given the working formula from the Deski report:

=ToDate(7+"/1/"+<Current FY>-1 ,"mm/dd/yyyy")

I tried to convert this using the syntax I know from Webi:

=ToDate(7+"/1/"+[Current FY]-1 ; "mm/dd/yyyy")

I faced the error message

The expression or sub-expression at position 8 in the '-' function uses an invalid data type

I am guessing this has something to do with trying to convert a date datatype into an integer in order to subtract "1." However, I do not know what kind of function this requires.

Thanks in advance!

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
Amanda A
  • 23
  • 5
  • Is [Current FY] a string? – Joe Jun 05 '14 at 16:11
  • @Joe no, it's a date returned as a number, given by this: = If (MonthNumberOfYear(CurrentDate())<7) Then Year(CurrentDate()) Else Year(CurrentDate())+1 We figured out that one by using FormatNumber: =ToDate("07/01/"+FormatNumber(([Current FY]-1); "0000"); "MM/dd/yyyy") and that ended up working. – Amanda A Jun 05 '14 at 21:04
  • 1
    @AmandaA Could you please flag your question as answered by adding the solution mentioned? That way, it won't keep showing up as unanswered. Thanks. – DocZerø Jun 17 '14 at 07:37

0 Answers0