LYTD showing only one record vale

[arulsettu]

hi,

     i am trying to show lytd values below code i used

=sum({<ACNT_FLEX_03={'1- Gross Premiums'},TD_DRCR_FLAG={'D'},TBAL_CAL_YEAR=,datefield={">=$(=date(YearStart(max(datefield),-1)))<=$(=AddYears(max(datefield),-1))"}>}TD_AMT_LC_1)-sum({<ACNT_FLEX_03={'1- Gross Premiums'},TD_DRCR_FLAG={'C'},TBAL_CAL_YEAR=,datefield={">=$(=date(YearStart(max(datefield),-1)))<=$(=AddYears(max(datefield),-1))"}>}TD_AMT_LC_1)

but the result is showing incorrect valeus

can anyone check above code is correct

Thanks

[arulsettu]

any idea?

[jonathandienst]

Looks syntactically correct to me. I suggest that you post a sample to show what you get and explain what you are expecting. Its a lot easier (for you as well) to ensure that this statement

=sum({<datefield={">=$(=date(YearStart(max(datefield),-1)))<=$(=AddYears(max(datefield),-1))"}>} TD_AMT_LC_1)

works correctly before trying to work it out in the full expression above.

[#4]

Hi,

sum({<SaleDate={">=$(=date(YearStart(max(SaleDate),-1)))<=$(=AddYears(max(SaleDate),-1))"}>}Sales)

This part is correct, can't say about your other modifiers, break your expression in steps and then check which one is incorect.

Regards,

Navdeep

[PrashantSangle]

Hi,

Try this

=sum({<ACNT_FLEX_03={'1- Gross Premiums'},TD_DRCR_FLAG={'D'},TBAL_CAL_YEAR=,datefield={">=$(=date(AddYears(YearStart(max(datefield)),-1)))<=$(=AddYears(max(datefield),-1))"}>}TD_AMT_LC_1)-sum({<ACNT_FLEX_03={'1- Gross Premiums'},TD_DRCR_FLAG={'C'},TBAL_CAL_YEAR=,datefield={">=$(=date(AddYears(YearStart(max(datefield)),-1)))<=$(=AddYears(max(datefield),-1))"}>}TD_AMT_LC_1)

Regards

[arulsettu]

Hi Jonathan,

                    here is the sample data.

                        it shows energy value as 182000

when i check my db i have value like this

          acc code    value

Energy	319001	-182000
Energy	319003	-75843.327

in my chart it shows for account code 319001 value

why its not showing other records

[jonathandienst]

That's too large, see here:

Preparing examples for Upload - Reduction and Data Scrambling