Hi,
I am tryimg to restrict measure KSL On basis of my attribute cost element.....i want KSL Value where cost element is not blnk. i am trying this by creating calculating measure in my view... i had put below formula .... but it doesnt work....
if(cost_elem != ' ' , KSL).
i had think of restricting my attribute cost element NE Blank......then my measure value will come how i wants........ but i am not able to find formula in my restriction or calculation .....either ways....
Please suggest how to use that function.....
Thnksss
Kulwinder
Kulwinder,
RKF should work for your scenario.
Regards,
Rama
Hello Kulwinder,
My thoughts:
in the SAP HANA the null is represted as "?" symbol.
in you case Restricted measure can work.
or other you case use calcualted measure
if("cost_elem != ?, KSL,0) (correct if syntax)
by using above expression if cost element does not equal to null then return KSL otherwise return 0.
Please try this. hope it helps.
Regards,
neha
Hi Kulwinder,
I faced similar issue and did something "equal" but different, try greater than 0 on your formula.
Also, if your table is replicated from ERP by SLT it should never have null values inside it, of course if it's a result of left join it can be null.
Regards, Fernando Da Ros
Add a comment