Calculated column not showing in Counter

[former_member184624]

Dear HANA Experts,

I am trying to use calculated column inside the counter. While selecting, the system is showing only dimensions and NOT showing Calculated columns. Please suggest, how to proceed on this.

Thanks.

[former_member184624]

Dear HANA Experts,

Can you please guide me, how to achieve in calculation View. Sample data attached.

In one of the Bex query, Restricted keyfigure is created. In this, we have below conditions. "Record Type" = 'PO' AND "Purchase Order Number" IS NOT NULL AND STATUS = 'CLOSED'.

Steps i tried.

STEP 1 : Created calulated column, and applied above restriction through if condition.

STEP 2 : Created Counter in aggregation node and tried to include the calculated column in the Counter. But system is not showing the Calculated columns inside counter. Only Folder is available, but Calculated columns are not showing.

Can you please guide me how to achieve this calculation view.

Thanks.

image.png

[venkateswaran_k]

Is this your problem solved?

[venkateswaran_k · Accepted solution]

Hi

Can you show us how did you create the Calculated Column.

Put some default value to the calculated column say integer ( 1 or 0 zero).

[former_member184624 · Accepted solution]

Dear Venkat,

Thank you for your comments. Please find the below snap. WK_COUNT is a column, where it stores the Value as "1". Please suggest how to proceed.

[venkateswaran_k · Accepted solution]

It should work...

What is the data type of wk_count ?

Can you please try with hard coded 1 or 0.

Can you please check, the calculated column properties

Data type : Integer

Formula : your formula

Aggregation : Formula <===

[former_member184624 · Accepted solution]

Thank you Venkat. For other calculation column i need to use purchase order and purchase order line in the flow. I want to count based on the purchase orders and not on purchase items. Can you please suggest how to achieve this.

Thanks.

[venkateswaran_k · Accepted solution]

Hi

Based on your initial question, Are you able to see the Calculated column in Aggregator?

Do you want to add another calculated col?