Percentage issue with column

[Former Member]

Hello,

I am having issues with a column in my report I am developing. The formula for the column is:

=Sum([Condition1] In([Condition2]))/Sum([Condition1] In( [Condition3]))

Now, we already have a version of this report in production. The version I am developing shows 100.00% for data in all cells of this column. The prod version shows the correct varying percentages for each row (74.56%, 3.5%, etc.). Any suggestions as to how I can produce the correct data on my dev report? The formatting and formula are the same in both prod and dev.

Thank you!

[Former Member]

 =Sum(Condition1 In(Condition2))/Sum(Condition1 In( Condition3)) 

As per the context syntax definition, the only context operator that can be within the aggregator paranthesis is ForEach. The input context will be placed outside the aggregator.

 =Sum([measure] ForEach [Dimension]) 

or

 =sum([measure]) in ([input context]) in [output context]

[Former Member]

Hi,

There are two things that you can check. Check if the merging of dimensions is in sync with the prod report and also check if there are any report level filters.

[Former Member]

I have walked through the same problem too ... but never got a fix. Did you try foreach() function???

A round about way is to use breaks instead of sections... but i do not remember if it addressed the problem completely.

If you can share any other fixes it would be v.helpful

[Former Member]

Hi,

Could you please confirm if the report points to the same data or does the data also have dev and prod environments.

If there are different environments, then please check if the development data is in sync with production data.

Thanks,

Vaibhav

[Former Member]

Yes, the report does point to the same data.