Untitled

mail@pastecode.io avatar
unknown
plain_text
a year ago
637 B
3
Indexable
Never
Planificado LH = 
VAR vFiltro = SELECTEDVALUE(Filtro[Filtro])
RETURN IF(vFiltro = "Horas", IF(NOT(ISBLANK(ALLPROJECTS[Proyecto (relacion)]), CALCULATE(SUM('Project LA'[Hours SGTO])), IF(ISBLANK(SELECTEDVALUE('Project LA'[Project])), BLANK(),  IF(CALCULATE(SUM('Project LA'[Cost Project Plan]))<1 , "0 €" , FORMAT(CALCULATE(SUM('Project LA'[Cost Project Plan])) ,"#,###.#0 €"))))

IF(vFiltro = "Horas", CALCULATE(SUM(Worklines[Hours SGTO])), IF(ISBLANK(SELECTEDVALUE(Worklines[Project])), BLANK(), IF(CALCULATE(SUM(Worklines[Cost Project Plan]))<1 , "0 €" , FORMAT(CALCULATE(SUM(Worklines[Cost Project Plan])) ,"#,### €"))))