Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have something like this.
Product TypeProd A B
1 7145 1000 0
2 7289 0 2000
3 4888 2500 0
4 7265 3200 0
5 1477 0 500
6 3655 1000 0
7 1788 1500 0
So, i want sum(A) - Sum(B) but only when TypeProd start with 71 or 72 and i want to do this in script. Any ideas?
Thanks in advance
Best Regards
Bruno Paulo
May be this
LOAD Product,
TypeProd,
A,
B,
If(WildMatch(TypeProd, '71*', '72*'), A-B) as NewColumn
From ....
May be this
LOAD Product,
TypeProd,
A,
B,
If(WildMatch(TypeProd, '71*', '72*'), A-B) as NewColumn
From ....
I have Time (Year and Month) as dimension it appear some results without time associated and negative values. (it shouldnt happen).
Any other idea?
If(WildMatch(TypeProd, "71*", "72*"), A-B) as NewColumn
- Double quotes should do the trick. Let us know if it doesn't work.
I guess Sunny Solutions is almost rigth in terms of values, but it creats 1 bar without time associated and i can't get it why. The double quotes didn't work.
Without time? Where is Time coming from? May you need to check 'Suppress Zero Value' on presentation tab?
Yes, supress Zero Value solved the issue. Thank you Sunny, perfect as always. Regards