cancel
Showing results for 
Search instead for 
Did you mean: 

Sap fiori case error

shiz0frenik
Participant
0 Kudos
196

HI,guys, i've got a problem with case statement in my cds view.
I try to delete decimal part, but only if it's eqals to 0.
field1 here's intitializes with floor(Menge).


Here's my code. (It's work, values with decimal part which eqals 0 get floor(Menge) value,values with decimal part NOT equals 0, get 0 value. But when i tru to replace "else 0", with "else Menge" all values get Menge value. Why
it's works like this. And what i need to do to remove decimal part if it eqals to 0. So first img is with "else 0",second
with "else Menge".


        case 
         when field1 = Menge   then floor(Menge)
          else 0
        end as field2

jmuiruri
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi shiz0frenik,

SAP Data Services and SAP Fiori are two completely distinct products, please tag your question correctly.

https://help.sap.com/docs/SAP_DATA_SERVICES

https://help.sap.com/docs/SAP_FIORI_OVERVIEW

Best Regards,

Joseph

Accepted Solutions (0)

Answers (0)