cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying 2 units in the result in query

Former Member
0 Kudos

Hi ,

I have calculated kay figure in my query as

Invoice Amount = Invoice unit cost Amount * Invoice Quantity .

So when I am running this query I am grtting 2 units in the result

it is like $xxx.xxEA.

How do I remove EA? I need only $ unit

Any help would be gretly appreciated.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello there,

just use nodim(Invoice Quantity) function for Invoice Quantity in your formula.

Sarhan.

Former Member
0 Kudos

Sarah ,

I did that but my overall result is showing wrong data now.Because I want the data before aggregation and when I go to the properties of my Calculated KF it is greyed out . I cant change it to before aggregation.Any Idea???

Thanks

Former Member
0 Kudos

Hello there,

I do not understand the problem. before using Nodim()was your result correct?

Sarhan.

Former Member
0 Kudos

Hey ,

I figured out..

earlier my results were wrong and after using NODIM they are now showing the correct multiplication .

Thanks a lot.

Answers (0)