Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this calculated value:
(SUM({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000)/(SUM({<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000)
And it's working
But when i try to do this it doesn't work. I don't know why. It doesn't show the field.
if (AGRUPA_CONCEPTO= 'POR_BONIF',
(SUM({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000)/(SUM({<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000),
SUM(VALOR) / 1000)
This is because i'm using the same field in the set analysis and in the if conditional? I used this with an 1 and it works. Do you know why this isn't working?
Thank you
Greetings
Try this:
If(CONCEPTO = 'POR_BONIF',
(SUM({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000)/(SUM(TOTAL {<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000),
SUM(VALOR) / 1000)
Thank you! but it didn't work. It's the same with or without total
Greetings
What are you seeing 0 or - when you use your expression?? Can you try them as two separate expressions and see which one isn't working??
If(CONCEPTO = 'POR_BONIF', (Sum({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000))
If(CONCEPTO = 'POR_BONIF', (Sum(TOTAL{<CONCEPTO = {GROSS_SALES} >}VALOR) / 1000))
See which one isn't working
I don't see 0 or -.
directly i don't see the dimmension 'POR_BONIF'
I see only the else, the 'VALOR)/1000)'
You don' see the the dimension 'POR_BONIF'?? Why not?? I don't really undertand the issue here, can you share a screenshot of what you are seeing???
If BONIFICACIONES_TOTAL and GROSS_SALES are Fields try to use P() in Set Analysis
AGRUPTA_CONCEPTO=P(BONIFICACIONES_TOTAL)
CONCEPTO=P(GROSS_SALES)
The field POR_BONIF. yeah, i don't see it.
Because the first part of the expression isn't working
So this expression isn't working?
If(CONCEPTO = 'POR_BONIF', (Sum({<AGRUPA_CONCEPTO={BONIFICACIONES_TOTAL}>}VALOR)/1000))
Can you send us a sample of your data??