Expression

[Anonymous]

Hi everyone!

I have one table like this:

itemnumber	Beginning Quantity	Beginning Amount	WA	CQ	CA	DQ	DA
100	5	10	2	2		5
200	2	11	5.5	3		3
300	3	12	4	1		3

I would like to calculate CA and DA columns based on this formula: CA=CQ*WA and DA=DA*WA and then present below table:

itemnumber	Beginning Quantity	Beginning Amount	WA	CQ	CA	DQ	DA
100	5	10	2	2	4	5	10
200	2	11	5.5	3	16.5	3	16.5
300	3	12	4	1	4	3	12

How can i do this?

[bhaskar_sm]

Hi,

Can you clarify this " DA=DA*WA" ?

[Anonymous]

sorry DA=DQ*WA

[supriya10]

hello,

If you are using Straight Table, Item Number is your dimension and all other are your Measures,

then label each Measures and use which field you want in calculation with their labels

[vishalarote]

In DA * WA Initially DA is Null if you multiply with null value with WA it becomes null.

So What is DA in your expression?

[bhaskar_sm]

Hi,

please find attached the Qvd. you can calculate this in Bakend using script and front end as well ..

if you found this helpful, please mark helpful or correct.

regards,

Bhasker