IF Function

5 posts, 0 answers
  1. Nathaniel
    Nathaniel avatar
    68 posts
    Member since:
    Nov 2010

    Posted 15 Nov 2011 Link to this post

    What does the IF function support?   

    This works
    If(TRUE, 2, 3)  ... returns 2  

    so why doesn't this work
    IF(TRUE, 2.3, 3.2)
  2. Maya
    Admin
    Maya avatar
    4062 posts

    Posted 16 Nov 2011 Link to this post

    Hello Nathaniel,

    I have tested the expression you mentioned on our demo, but still I get correct result. Please take a look at the image attached to verify whether I am missing something in my attempt to reproduce the case.
      

    Kind regards,
    Maya
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. DevCraft banner
  4. Nathaniel
    Nathaniel avatar
    68 posts
    Member since:
    Nov 2010

    Posted 16 Nov 2011 Link to this post

    I cant reproduce what I wrote up yesterday. It works as expected today. Thanks for the quick reply.
  5. Nathaniel
    Nathaniel avatar
    68 posts
    Member since:
    Nov 2010

    Posted 16 Nov 2011 Link to this post

    Maya, Can you answer a question I asked before about the Pow() function

    In the first look example I change the first rows UnitPrice to 3.3.  Then I change the expression to be

    Pow(UnitPrice, UnitPrice)   this works

    but

    Pow(3.3, 3.3)  does not

    but

    Pow(3, 3)  works

    What does the Pow function accept?
  6. Maya
    Admin
    Maya avatar
    4062 posts

    Posted 17 Nov 2011 Link to this post

    Hello Nathaniel,

    Actually, this is not the expected behavior and we have already logged it into our Public Issue Tracking System. You can follow its progress here.
    For the time being I could suggest to insert the function as follows - Pow(2.5e0,2.5e0).
    Thus the parser will be aware that those are decimal numbers and will be able to calculate the function.

    Greetings,
    Maya
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

Back to Top
DevCraft banner