Problem with data model

[#1]

Hi All,

I have 3 tables PNL, Billing, Revenue. i used Billing doc num as common key for this tables (Please check the data model).

Based on requirement i used expressions and i'm getting data correctly but values are repeating and also

for Expression1 i'm getting sum of the value instead of individual value (193+193+121=507).

i'm not getting total value of second expression also.

could you please help me to get the data as below

i'm also attaching QVW, Could you please anybody give the solution asap would be great for me.

Thanks,

MV

[#2]

Hi Guys,

it's an urgent requirement, could you please anybody help on this?

Thanks,

M V

[PrashantSangle]

Hi,

Kindly find attached application,

It is as per requirement.

Regards,

[#4]

Hi Max,

Thank you very much for your reply.

For first expression it is working fine but for second expression (based on some conditions) values are not coming.

Could you please take a look into this.

Thanks,

M V

[jagan]

Hi,

Try this expression

sum(aggr(if(Match(DOC_TYPE, 'Q1', 'D4', 'Z4') AND Match([Accrued_Revenue_Clearing_GL_Account_Id], '2507RR9999', '2509RR9999'),

Sum(Amount2)-sum(Amount1),if([Offsetting_GL_Account_Id]='1221RR9999',sum(Amount1))),Key1))

Regards,

Jagan.

[PrashantSangle]

Hi,

Try this expression,

Sum(aggr(if([Accrued_Revenue_Clearing_GL_Account_Id]='2507RR9999' or [Accrued_Revenue_Clearing_GL_Account_Id]='2509RR9999',
Sum(Amount2)-sum(Amount1),if([Offsetting_GL_Account_Id]='1221RR9999',sum(Amount1))),Key1))

Regards

[#7]

Hi Jagan,

Thanks for your reply.

If i use the above expression i'm getting 0 as values.

if possible could you please take a look into this.

Thanks,

M V

[jagan]

Hi,

Check this file attached.

Regards,

Jagan.