on 09-12-2014 8:45 AM
Hi All,
We ave a key figure in the selection screen. And user will enter the value. based on the input, the report has to display less than or equal to the entered value as a result in the output of the report.
Input NIV as 67,169.48 then below results -
If user gives input NIV as 16,544.14 , the below output is showing.
But we need to show zero as result or no applicable data in the report. Is it possible to achieve through FORMULA.Please help on this
Thanks.
Hello Jalina,
Try to suppress the result row and you will get the no applicable data in the report. Please let me know the result.
Regards,
Prabakar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jalina,
Yasemin already asked few questions.
but this is what we may do:-
to create a formula variable and use it for user input. use this formula variable in a formula , if your NIV kf<= formula variable, then NIV KF, else, 0.
then make a condition on this KF, not equal to zero to suppress this record.
regards,
Sakthi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Already we created formula like
(NIV <= USER INPUT) * NIV + 0
with this if user has not given any input in NIV , results coming with 'X' in cloumn.
If user give input on NIV, then getting desired results as expected.
But issue here is, if user not given input in variable screen, still it has to show required data.
Hi Jalina,
Please explain in more detail, how you added the selection variable for NIV. Is it a variable defined by a condition or is that a variable defined as formula variable and used it in creating NIV? Answer may depend on that.
Regards
Yasemin...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.