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 a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

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

    what are you trying to achieve with this formula?

    Add a 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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 a comment
    10|10000 characters needed characters exceeded

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

    thanks

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.