#Scn coding r350 command how to#

I have created (1) Total units sold <= and (3) Sales value <, but not the 'count of stores with sales <=' as I do not know how to create the latter, but more about that later. One conditions with three structures is required: The client wants to identify products that are not selling in their stores. Which means the Collateral agreement ''80000000752'' has highlighted value 3341992,00.Д«ut what result i see is maximum of all the Collateral agreements.ДЄs per the design i expected query to behave as expected but not sure what is going wrong where.

Now TD CAG has to show maximum TD CTR value of the Collateral agreement for that Contract. TD CTR is showing right value which is sum of two values shown above for contract number 10003004 which is 5497380,21. The aggregation on TD CTR is ''Maximum on Contract Number''. The aggregation defined for TD CAG is ''Maximum on Collateral Agreement''.ДЄlso TD CTR is a New Formula defined in Query and it contains another standard Key Figure ''Tenancy Duration''.

TD CAG is a New Formula defined in Query and it contains the KPI ''TD CTR'' in formula editor. But i am getting 4685626,54 in the result. What i expect for TD CAG KPI is the value highlighted - 3341992,00. However the report does not show right expected result. I have a scenario in my report where there are aggregation levels defined.

Scn coding r350 command