Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi , i'm new to QV but i'm trying my best.
In my example i need to create 2 new columns that would sum the expressions "Local Amount" and "Remmitance Amount".
Is that possible and if yes, what is the syntax?
Try this:
=sum({<merchants={'CBMS','CBMS-PayPal'}>}[Local Amount])+
sum({<merchants={'CBMS','CBMS-PayPal'}>}[Remmitance Amount])
A simple "+"-operation should work
=sum([Local Amount])+sum([Remmitance Amount])
Thanks Gregor but it seems that i didn't explain myself correct.
I need to sum in a new column (in my example) the [Locale Amount] (Expression)of CBMS and CBMS-PayPal which are diffrent merchants(Dimention). the same thing i need to do to the [Remmitance Amount]
I actually sum(Locale Amount] in its dimention anyway.
Thanks,
Avishay
Try this:
=sum({<merchants={'CBMS','CBMS-PayPal'}>}[Local Amount])+
sum({<merchants={'CBMS','CBMS-PayPal'}>}[Remmitance Amount])
Thanks you very much, it helps.
One more thing. CBMS and CBMS-PayPal can be anything else from the DB which means that the report don't know the merchant names.
Is there any generic formula for this?
Try this:
=sum({<merchants={'*'}>}[Local Amount])+
sum({<merchants={'*'}>}[Remmitance Amount])
This will Consider all the merchants from the database.