Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i need to count in a line chart, a field than satisfy a fiflter, esample:
if(GetFieldSelections(CD_FORNITORE)='XXX',
Sum({<CD_FORNITORE1={"XXX"},[FORNITORE1]={'XXX SOC'}>}NRPOD)
, ''
)
CD_FORNITORE : is a field of my TABLEA (i have a filter in a dropdown button of that
in my TABLEB i have a filed CD_FORNITORE1
so i want SUM NRPOD of my CD_FORNITORE1=xxx AND FORNITORE1=xxx soc
it must satisfy that in my TABLEB becouse in that table i need to count the NRPOD where satisty only that
Hi, i did it thank in this mode:
dual(( | |
num(Sum({<[cd_fornitore1]={'xxx'}>}[NRPOD]),'#.##0;(#.##0);-') | |
) & chr(10) & chr(10), ( | |
num(Sum({<[cd_fornitore1]={'xxx'}>}[NRPOD]),'#.##0;(#.##0);-') | |
)), |
Would you be able to share some sample data to elaborate on your issue?
Hi, i did it thank in this mode:
dual(( | |
num(Sum({<[cd_fornitore1]={'xxx'}>}[NRPOD]),'#.##0;(#.##0);-') | |
) & chr(10) & chr(10), ( | |
num(Sum({<[cd_fornitore1]={'xxx'}>}[NRPOD]),'#.##0;(#.##0);-') | |
)), |