Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi my friend, I have the next set Analysis:
Presupuesto:
=((Sum({<[ACCNT_CODE]={"611110", "635110", "635120", "635140"}, [FNCT]={"DT*"}, [LEDGER]={"B"}, YearPeriod = {$(=(max(YearPeriod)))}>}[AMOUNT])))
Real:
=(if([YearPeriod] <= '2021' and [MonthNumPeriod] <= '1', (Sum({<[ACCNT_CODE]={"611110", "635110", "635140"},[LEDGER]={"A"}, YearPeriod = {$(=(max(YearPeriod)))}>}[AMOUNT])),
(Sum({<[ACCNT_CODE]={"611110", "635110", "635140", "368235"},[LEDGER]={"A"}, [FNCT]={"DT*"}, YearPeriod = {$(=(max(YearPeriod)))}>}[AMOUNT]))))
Diferencia:
=(if([YearPeriod] <= '2021' and [MonthNumPeriod] <= '1', (Sum({<[ACCNT_CODE]={"611110", "635110", "635140"},[LEDGER]={"A"}, YearPeriod = {$(=(max(YearPeriod)))}>}[AMOUNT])),
(Sum({<[ACCNT_CODE]={"611110", "635110", "635140", "368235"},[LEDGER]={"A"}, [FNCT]={"DT*"}, YearPeriod = {$(=(max(YearPeriod)))}>}[AMOUNT])))) -
(Sum({<[ACCNT_CODE]={"611110", "635110", "635140"}, [FNCT]={"DT*"}, [LEDGER]={"B"}, YearPeriod = {$(=(max(YearPeriod)))}>}[AMOUNT]))
In the next Table:
I Want count the positive values (green) 16, and negative value (red) 2 in a KPI...
Thanks in advance!...