Monthly Percentage

[cristianj23a]

I have a problem with the percentages.

The objective is to calculate the percentages based on the monthly total.

As it is displayed in the image.

the value 1535623.52 is the total for the month of December. This value should be in the Exp2 column.

The same logic must be repeated in each month.

please help me with this topic.

Greetings.

Attached the Qvw

[sunny_talwar · Accepted solution]

Try this for total

If(Dimensionality() = 2,

Sum(TOTAL <NOM_MES> {<FECHA_STOCK={"$(=DATE(NOW()-1,'DD/MM/YYYY'))"},ALMACEN={'*'} - {'290010','390010','930102'}>}STOCK_M2),

Sum(TOTAL{<FECHA_STOCK={"$(=DATE(NOW()-1,'DD/MM/YYYY'))"},ALMACEN={'*'} - {'290010','390010','930102'}>}STOCK_M2))

[vishsaggi]

try this in your expr2

= sum(TOTAL <NOM_MES> {<FECHA_STOCK={"$(=DATE(NOW()-1,'DD/MM/YYYY'))"},ALMACEN={'*'} - {'290010','390010','930102'}>}STOCK_M2)

[vishsaggi]

Sunny I thought he said he wants to repeat this for every month not only in Dec so will adding NOM_MES is not enough? Just wondering to know.

[vishsaggi]

You are right his %ges gets weird if we do not use Dimensionality. Got it.