01-09-2023 10:48 AM
Hey guys! Happy new year. Do you know if there is a way to use more than one dim in the lif section for a calculated field in BI Viewer?
Thanks a lot!
01-09-2023 01:46 PM
Use filter.
filter(Sum([Amount]),[Field1]='Criteria1' && [Field2]='Criteria2')
01-12-2023 02:14 PM
this worked haha Iif([Account] Like '%[Field2]%' And [UD3] like '%[Field2]%', [Amount], 0)
Thanks!
01-09-2023 02:01 PM
I will try, thanks!