Selling Rate

[Anonymous]

Here is another one...

I have an excel table with 45 items where 28 have the value "sold".

What I try to do is creating a calculation, Selling Rate in %, that calculates

# of Sold items / # of all items.

I want to have this displayed next to my chart.

Can anyone help here?

spijatida

[reshmakala]

Attached. Let me know if any questions

[consenit]

Hi there.

Use a text box with an expression like:

=NUM(COUNT( {$<value={'sold'}>} item) / COUNT(item), , '#.##0,0%')

substitute the fields names item and value to match your data.

Kind regards,

Ernesto.

[Anonymous]

Hmm... I get an error in expression

=NUM(COUNT( {$<Status={'Sold'}>} Status) / COUNT(Status), , '#.##0,0%')

[kamielrajaram · Accepted solution]

Hi,

Remove the second comma before you number format.

Regards

Kamiel

[MarcoWedel]

can you provide sample data/app?

regards

Marco

[Anonymous]

duhhh!! Not my day.. thanks Kamiel!!