Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
As shown in the sample document, how can show a new column where its available= 1 and sum of that particular type?
so I would like to see sum of typeA, 3+4+3 = 10, sum of typeB = 4 and so on...
Thanks and best regards,
Chanel
Sorry, Try this one. It does fit the sample data but may not easily scale to fit your full data set...
If(F1='TypeA',sum({<F1={'TypeA'}>}TOTAL F2*F3),
If(F1='TypeB',sum({<F1={'TypeB'}>}TOTAL F2*F3),sum({<F1={'TypeC'}>}TOTAL F2*F3)))
Try this
=Aggr(Sum(F2*F3),F1)
oops!! strangely the symbol got converted, you can try the below modified expression:
=If(F1='TypeA' and available='1', Sum({<F1={'TypeA'}>}TOTAL F2*F3),
If(F1='TypeB' and available = '1',Sum({<F1={'TypeB'}>}TOTAL F2*F3)))
This will not show anything in the rows where available is not 1, you can add 0 or '-' per you requirement.
Hope this helps!
Hi,
Check attached File,
Regards,
Hi chanel,
I am not sure why you need such output where you can easily get with partial sum features.
anyways PFA I have done in all 3 forms may be helpful for you.
have a look at the attachment