Skip to Content

Please go through this

I have an object name like month name which has the following months april,may,june,august.I want to apply pos formula for all these months,how can i write formula for all. I have created a variable and I have tried like

=If DrillFilters([Month Name])="August" Then Pos([Month Name];"ugst") ElseIf DrillFilters([Month Name])="April" Then Pos([Month Name];"ril") Else .......but i got #Multivalue

Please help.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Posted on Apr 29, 2011 at 11:38 AM

    what are you trying to achieve with this formula?

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 29, 2011 at 10:22 AM

    Hi,

    As per your above formula you have created condition only for August and April.but in the post there are four months .so you have to create elseif condition for three month and for forth month you can put in the else part.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Apr 30, 2011 at 03:21 AM

    hi

    what you trying above is working for me , both in blank cell and in separate column, what is your exact requirement ?

    Regards

    Dineshkumar

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 01, 2011 at 02:43 AM

    Hi, #Multivalue is Webi telling you that it got more than one result for your formula. This means that in the part of the screen where you're viewing the result, there could be more than one month. Does this only occur when no drill filter is selected?

    Does your formula end with "else" or "elseif"?

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2011 at 05:01 AM

    thanks

    Add comment
    10|10000 characters needed characters exceeded