Need to show No applicable data in the report.

[former_member184624]

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.

[former_member465829]

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.

[Former Member]

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.

[former_member184624]

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.

[Former Member]

we can have one more condition included..if user input is blank i.e = 0 i guess,then just show NIV in the same formula.

Regards,
Sakthi

[yasemin_kilinc]

Hi Jalina,

I am not sure if it will work but can you please try this formula?

(NIV <= (USER INPUT>0)*USER_INPUT) * NIV + 0

[former_member184624]

we tried with above formula,but no use , output coming as 'X'

[yasemin_kilinc]

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...