This content has been marked as final. Show 4 replies
I have the challenge, I have a field called "TIPOMEDICION" that has two values "official" and "backup", I am using the dimension called "PUNTOSIMEC".
It turns out that I have data from the official pointsimec and backup, but sometimes I only have data from the official and not from the backup or vice versa, the challenge is that when there is data in the official pointsimec I add the data, but if there is data that adds me the data of the Puntosimec backup.
For this example I have two points loaded 40-4-81 & 40-82 but I do not have data from the official pointsimec of 40-4-82 but I need to add the data of the backup to complement.
I hope you have made me understand.
SUM(If([TIPOMEDICION] ='OFFICIAL' AND [KWHR]>0,[KWHR]/1000))