Skip to Content

#Multivalue error showing balances per customer

I'm trying to show a webi table with open item balances per customer, with line items in different currencies for the same customer. I'm obtaining info from BSID for open items and tcurr for exchange rates

I've this initial table :

Saldo EUR formula, where Saldo en Moneda de origen is Sum of line items ammount.

So my problem is I'd like to show initial table without Currency ("Clave de moneda"), because I'd like to display the amount per customer in one line. If i delete "Clave de Moneda" from table, #multivalue error is shown:

I understand problem is caused because there is a totall amount for Saldo EUR per currency, but i cannot find a solution.

Any ideas?

Regards,

Francisco Lasso

table.jpg (38.9 kB)
saldoeur.png (30.5 kB)
multivalue.png (36.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 09, 2016 at 03:48 PM
    12

    Hi Francisco ,

    use =sum() for your IF condition .

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 13, 2016 at 02:28 PM

    Hi Mahboob / Amit. I've solved mi issue. Problem was with last foreach. Thank you so much for your help!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.