Skip to Content
author's profile photo Former Member
Former Member

Condition based on Input value by parameter

Hi experts,

I am looking for a solution in crystal reports in conjustion to BI . I m using Bex query directly for this report rathing creating an universe.

I am trying to create a RKF based on parameter value by user's input.

For example : - user input a date FROM-TO and than I am filtering minimum and maximum value . Based on these 2 values I have to restrict a KF Sales amount.

Whenever I try to do like this in formula I get this error. Can someone help me in that please ?

if ({ZCRETA_ZZCRETA_Q_001_TEST.[ZCALMTH]} <= {@Min}) then {ZCRETA_ZZCRETA_Q_001_TEST.[Measures]-[D6T7LZ8YG3KSRHCE821ZX1WVY]}

I also tried while do as well but did not work.Bascially I am trying to do something like this

If Calmonth <= Min ( already filtered by me from parameter's value ) than display sales amount.

As per this logic I should be able to see all the sales amount wherver Calmonth is less than of equal to minimum value of Calmonth.

Thanks in Advance,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2009 at 09:43 PM

    Hi, your statement is looking at a formula, not a parameter

    f ({ZCRETA_ZZCRETA_Q_001_TEST.ZCALMTH} <= {@Min}) then {ZCRETA_ZZCRETA_Q_001_TEST.Measures-D6T7LZ8YG3KSRHCE821ZX1WVY}

    If it was a parameter it should look like this

    if ({ZCRETA_ZZCRETA_Q_001_TEST.ZCALMTH} <= {?Min}) then {ZCRETA_ZZCRETA_Q_001_TEST.Measures-D6T7LZ8YG3KSRHCE821ZX1WVY}

    you may also need to add the else.

    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.