Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two tables
Table A
Country
Model
Table B
Model ( Few Models )
Cost
When I Left Join Table A with B for some Model which are not in table B Cost is
null. And when I use Pivot table to calculate count(Model)*Cost
and try to get subtotals I get 0.
Table A Tableb
Country Model Model Cost
A a 10
A
b e 14
ABC e f 12
e
F
XYZ a
b
Can you please help me to get proper subtotals.
Hi,
Use RangeSum(count(Model) * Cost)
Hope it helps
Celambarasan
Hii Nisha,
use the following expression.
count(Model)* if(isnull(Cost),0,Cost)
This will consider the null values as 0.
-Nilesh
Thanks Nilesh, I have already tried this but not getting the desired result.
Please find the result which I get in the Pivot table.
For some country I get the subtotal which is random and for tother even the subtotal is missing.
@Thanks,
Nisha
try this
count(Model) * if(Cost=' ',0,Cost)
Can you attach the sample app?
Hello Vishwaranjan,
Thanks. Its giving me correct total but the partial subtotals are still 0.00 and for some its random number.
Try this:
sum(
aggr(
sum( alt( cost, 0 ) )
,
Model
)
)
Doesnt help much.
use aggr function by declaring the field u want the aggregation for.... tht will solve the problem