Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have following inline table every value is a dimension in another table?
TableRevenueInline:
Load * inline
[
COL
PAS P1@Net List USD
PAS P1@Net Amount
PAS P1@Net Contra
];
in a pivot table I am using 'COL' as dimension
and in expression I have find out
sum (PAS P1@Net List USD) if value is COL='PAS P1@Net List USD'
sum(PAS P1@Net Amount) if COL= 'PAS P1@Net Amount'
sum(PAS P1@Net Contra) if COL = PAS P1@Net Contra
Please help me to write the expression to get the accurate value
Basic syntax of IF statement is like :
If ( <condition>, <execute when TRUE>, <execute when FALSE>)
Hence, you may try like:
If( COL='PAS P1@Net List USD', sum (PAS P1@Net List USD) ,
If( COL= 'PAS P1@Net Amount', sum(PAS P1@Net Amount),
If( COL = 'PAS P1@Net Contra', sum(PAS P1@Net Contra) )))
Hi,
As i see if your doing some aggregation function it should be numeric value but as per your requirement it seems your summing strings
elaborate the requirement it means is there any data linked to NEt list usd ,Netamount &Netcontra.
pick(wildmatch(COL,'PAS P1@Net List USD','PAS P1@Net Amount','PAS P1@Net Contra'),
sum (PAS P1@Net List USD),
sum(PAS P1@Net Amount),
sum(PAS P1@Net Contra)
)
You could try the dynamic expression:
=Sum([$(=COL)])
Thanks .. I tried this way and got the approximate value but not exact value
can you share expected output n what you are getting with this code?