9 Replies Latest reply: Jul 25, 2016 3:40 PM by fabio Mazzarelli

target

Hi Community,

how to prevent calculation of the formula is applied to the total row (red box)

(Sum(DIRFIS)

+ sum({<Commessa = {"=KeepChar(Commessa, '0123456789') * 1 > 10"}>} [TotOreLavorate])

+ sum({<Commessa = {'ASSCLI', 'ASSREM'}>} [TotOreLavorate])

+ sum({<CTRAAN = {'N',""},Commessa = {'ASSTEL'}>} [TotOreLavorate])

+ sum({<CTRAAN = {'T',""},Commessa = {'ASSMOD'}>} [TotOreLavorate]))

/ (85 * (count(MeseEsteso)))

• Re: target

May be use of Dimensionality() or SecondaryDimensionality() to get this done.

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

• Re: target

Have you considered using a straight table? With a straight table you can have the field NA/NN but it won't group by it and you can avoid the total row.

• Re: target

HI,

I understand the suggestion , but I would like to take the path indicated by Sunny . I hope I can give an example to follow

• Re: target

It was very simple . I found an example and I managed to figure out how to make it happen .
The dimantionality function allows you to have the level for each line and then just an IF to determine if the level should be tested or not.

if the level is 1, then I put " - " if the level is 2 I apply the formula .

if (Dimensionality() = 2,(Sum(DIRFIS)

+ sum({<Commessa = {"=KeepChar(Commessa, '0123456789') * 1 > 10"}>} [TotOreLavorate])

+ sum({<Commessa = {'ASSCLI', 'ASSREM'}>} [TotOreLavorate])

+ sum({<CTRAAN = {'N',""},Commessa = {'ASSTEL'}>} [TotOreLavorate])

+ sum({<CTRAAN = {'T',""},Commessa = {'ASSMOD'}>} [TotOreLavorate]))

/ (85 * (count(MeseEsteso))), '-')