How to calcul a % in this case ?

[Paaaaaaan]

Hello there.

Here's my question with a dummy file :

A (colum) = year

B = a reference number for an event

C = the income

D = unique number within an event (can have one or more unique number)

E = is this event a type EV or not.

I would like to know for the % of EV or not based on the B column (B must be distinct count, but i'm stuck here.)

[Anonymous · Accepted solution]

Hi Paaaaaaan,

If B Column is not unique, then you can combine two or three column and have a count of that column to calculate the percentage.

With this calculated column, you can proceed in calculating the %.

Regards,

Pradeep