Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following expression in a chart, which works fine
=round([Last calving]-[Date of birth])/30.4
I want to add the following selection to the expression but cant get it right
{<[Lact. no.]={1}>}
I have tried this:
=round({<[Lact. no.]={1}>}[Last calving]-[Date of birth])/30.4
Can anyone advise what I'm doing wrong?
Thanks
Try this:
=Round(Only({<[Lact. no.]={1}>} [Last calving]-[Date of birth]))/30.4
Try this:
=Round(Only({<[Lact. no.]={1}>} [Last calving]-[Date of birth]))/30.4
Thanks Sunny, that works perfectly