Total Amount Incorrect

[upaliwije]

I have in qv Document the following pivot table.

In the Difference the total shown is incorrect. It may be probably due to incorrect expression. pls look into this in my attached QV document and advise me to correct it

[Anil_Babu_Samineni]

Are you expecting 6693?

Can you share expression due to license issue

[upaliwije]

Yes 6693

My expression

=if(sum( {<R_YEAR=,R_MONTH=, [To_MONTH] = {$(=concat([R_MONTH],','))},[To_YEAR] = {$(=max([To_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )>0,

(sum( {<R_YEAR=,R_MONTH=, [To_MONTH] = {$(=concat([R_MONTH],','))},[To_YEAR] = {$(=max([To_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

-

sum( {$<[R_YEAR] = {'$(=max([R_YEAR]))'}>} [PREMIUM] ))

)

[prieper]

give it a try with

COLUMN(8) - COLUMN(7)

[upaliwije]

Then the results is

[prieper]

IF(COLUMN(8) <> 0, COLUMN(8) - COLUMN(7))

[Kushal_Chawda]

there is some syntax problem in your expression

try below

=if(sum( {<R_YEAR=,R_MONTH=, [To_MONTH] = {$(=concat([R_MONTH],','))},[To_YEAR] = {$(=max([To_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )>0,

(sum( {<R_YEAR=,R_MONTH=, [To_MONTH] = {$(=concat([R_MONTH],','))},[To_YEAR] = {$(=max([To_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )),0)

-

sum( {$<[R_YEAR] = {'$(=max([R_YEAR]))'}>} [PREMIUM] )

[upaliwije]

Then the result is

[upaliwije]

Still the desired result is not achieved

[sunny_talwar · Accepted solution]

May be this

=Sum(Aggr(if(sum( {<R_YEAR=,R_MONTH=, [To_MONTH] = {$(=concat([R_MONTH],','))},[To_YEAR] = {$(=max([To_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )>0,

(sum( {<R_YEAR=,R_MONTH=, [To_MONTH] = {$(=concat([R_MONTH],','))},[To_YEAR] = {$(=max([To_YEAR]+1))},POL_TYPE={'R'}>} [PREMIUM] )

-

sum( {$<[R_YEAR] = {'$(=max([R_YEAR]))'}>} [PREMIUM] ))

), POLICY_NO))