QTD Miscalculation

[former_member230848]

HI ,

whenI am using the period 2010.Q1 using

QTD measure. The YTD measure works correctly but QTD does not compute

correctly.

The QTD Measure is not working when we report on using 3 measures

Periodic, QTD and YTD with corresponding PNL Accounts. We are able to

get the correct results for Periodic and YTD, but not for QTD.

Regards

Prabhu

[former_member230848]

Hi Experts,

We have found a miscalculation within BPC 7.0 116 (for MS

Platform) For a YTD application it does not correctly calculate the first

period (JAN) of Income & Expense accounts. It is taking the difference

between Jan & Dec of the prior year

To replicate, setup AppShellu2019s Finance app as a YTD app. Then run a

trend report with the periodic measure. Jan will report a value that isthe difference between Jan and Dec of the prior year. Switch

to the YTDmeasure and Jan now has the correct value.

Is it any bug in this below code

PERIODIC measure formula should be modified like below.

IIF(NOT ([P_ACCT].PROPERTIES("ACCTYPE")="LEQ" OR

[P_ACCT].PROPERTIES("ACCTYPE")="AST") AND NOT ([TIME].PROPERTIES("I

SBEGINNING")="1"),[MEASURES].[YTD]-([MEASURES].[YTD],[TIME].LAG(1))

,[MEASURES].[YTD])

Thanks for response.

Regards

Prabhu

[Former Member]

Hi Prabhu,

You need to check 2 things:

1. What is the application type?

2. What is the measure you are using?

Based on the above answers, look at the measure accordingly in the measureformula table in SQL.

You can suit your requirement by either modifying it or by adding a custom measure.

The specified formula is correct. For the JAN month, it will not consider the previous years DEC; since the ISBEGINNING property of JAN should be 1. Have you maintained the ISBEGINNING property in your time dimension?

Hope this helps.

[Former Member]

Could you please process the application once and see whether the problem with QTD happens again?

[Former Member]

what is the value with QTD? is it consistenlty incorrect?

[former_member230848]

QTD miscalculation with Quartes

when it is giving correct

results for Q1 and Q3 based on the LEVEL Property and based on the same

LEVEL property giving incorrect results for Q2 and Q4