Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm sure I'm writing wrong this formula
=Sum({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento])/sum (total({<[Codice Documento]= {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}>} [QTA 1 Documento]))
I need to calculate the column percentage...how should it be written the formula? My problem is that this variable [Codice Documento] must respect those values {'CLI-SCONTRINO','NEG-FATIMM','FOR-DDTRESO','INT-BUONOSCA','SCA-DANN-FURTI'}....
thanks to everyone!
swuehl thank you for your reply though...
I was late, swuehl noticed the right spot.
swuehl 's formula is working for me. The location of 'total' before/after set analysis doesn't affect the result. Check attachment for your info.
you were right! I'm wondering why it wasn't working earlier when I copied and pasted the formula into my QV file...
Well thank you for the explanation I'm glad that the order of the set analysis doesn't affect the result!
a big thanks to all of you swuehl, Clever Anjos and @Yang LU