Attach workbook here.
IF [KPI]='YTD view' and [CY YTD] then ( [filed2]) end
as CYYTD is Boolean value which gives True or false
and field 2 is numeric which give some value
if condition will expect either numeric or boolean you cant give two data types in O/P If condition
Could you please attach a sample workbook to decipher your problem
I cant attached workbook here. Client data.
I have used this kind of if earlier in my dashboard. which was working fine. here i need to use
calculated filed(sum (value1 )/sum(value2)) .
if i remove sum from above , will give me wrong % value.
In your calculation of [CY YTD] boolean field , you need to make dimension ATTR. Something like
attr([Date/Time]) < date('2018-01-01')
Then it will be fine.