Passing negitive values to Input parameters in SAP HANA

[Former Member]

Hello Everyone!

I have an issue while passing input parameter as a Negative value to HANA View (Graphical). I have to get values for >10 and <-10. when I give negative value in input parameter it is ignoring entire filter statement and fetching Zero records.

Appreciate any help on the same.

[Former Member]

Hello, Paddy.

I'm not an expert, but it seems for me, that your expression contains logical inconsistency.

Maybe you mean values that >10 OR <-10? Or values >-10 and <10(between them)? Because there is no numbers that are greater than ten and less than -10 at the same time.

For >10 OR <-10 results can be: 11, 100, -20, -53

For >-10 and <10 results can be: 1, -4, 0, 7

For >10 and <-10 no suitable numbers.

Hope that can help if it really logic issue.