BW Data Type Conversion

[former_member766277]

Hello everyone,

I have a problem about getting divided of some formulas. I want to divide two formulas which is charactheristics of 0GLACCOUNT and 0MATERIAL_0MATL_TYPE. I'm using NDIV0 data function while I am dividing two formulas on my query however it did not work out.

I'm given the general logic below:

NODIM("[] x" / "[] y") (x and y are different type of data units. How can i convert them or which function should i use to understand hana both x and y have the same types?

Could you help me to solve this problem?

Best regards,

[Ian_Garrett]

Hi,

Can i please confirm a couple of points:

- Are you using exception aggreation to ensure that GL and Material are distinct before driving to do the divison?

- Have you tried doing a stepped approach ie Nodim(GL) as a KF and Nodim(MATL) as a KF then dividing?

Thanks

Ian

[former_member766277]

i_garrett Hello,

-I'm not using exception aggregation because i have a one calculation view and from that cv, i've made 3 queries. It may be spoil other queries.

-I've tried as it's shown below. I've created a key figure one. But not sure about the exception aggreagation part because i have to sum up and filter the 0GL_ACCOUNT.

For the 0MATERIAL_0MATL_TYPE, i need the filter it too.

I

[erdempekcan]

Hi,

What are the types of X and Y and what's the error you get?