If Function

[ramprakashs]

Hi,

I need a output as per the attached sheet, while applying the code I am getting '-' as result, Please correct my mistake.

Thanks in advance.

[dplr-rn]

The table values is not associated with the other table.

[ramprakashs]

Is there any other way to join two tables without any common fields.

Since I need the count based on the value, contractstage and sub_val.

[dplr-rn]

Not clear what you mean. you can easily count by contractstage,sub_val right now.
Just add that as the dimension
wrt value column. The scipt currently has only text there for that column it is not associated in anyway to main data. I think you need to apply your business logic and create it as a calculated field in your load script. like you are doing for sub_val

[ramprakashs]

Thank you I got an idea on how to do, but when applying two conditions i am getting the desired result while applying three conditions i am not getting what i expect. Can you please advise me regarding this.

[dplr-rn]

Did you create the value column as calculated?

[ramprakashs]

Yes.

[dplr-rn]

Share updated app and explain the error.

I will take a look

[ramprakashs]

Hi Please find the script file, I have added the values in the table so it takes the count based on it.

[dplr-rn]

What is the issue? the numbers look correct from first look