Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I'm having problems with building a formula. This picture shows it best.
The CALC1 field should Always be the total of the productgroup: baseset.
I've succeeded with doing that with for the first part with the formula
SUM(TOTAL <[PRODUCTGROUP]> AMOUNT)
Unfortunately I can't get it to work when the table hits the productgroup "Sales".
See the picture.
SUM(TOTAL <[PRODUCTGROUP]> {<PRODUCTGROUP={'BASESET'}>}AMOUNT) doesn't do the trick.
I've included a .qvw file with script and GUI. Can anyone help? Thanks!
Use a helper variable. For example vTotal_BASESET: =sum({<PRODUCTGROUP={'BASESET'}>}AMOUNT)
See attached qvw.
Hi,
Use CALC1 formula as
$(=SUM( {<PRODUCTGROUP={'BASESET'}>} AMOUNT) )
Use a helper variable. For example vTotal_BASESET: =sum({<PRODUCTGROUP={'BASESET'}>}AMOUNT)
See attached qvw.
Thanks! That solves it!
I'm absolutely surprised to see that the formula does not work when coded into the expression, but that it does work when using a variable.
Thanks!
oh wow. It seems I got 2 correct answers!
Thanks for this one too.