Secondary data source contains a dimension that is T/F.
A calculated field was created based on that dimension because I couldn't directly use it, the calculated field returns 1 if true and 0 if false.
That calculated field needs to be compared to a parameter that is T/F to determine which rows to sum.
How can I compare the parameter to the secondary data source calculation since 1 or 0 doesn't appear to match up with true or false automatically.
If I could just set the IF to return true/false I wouldn't have any issues I believe but I'm not allowed to do that for some reason.
Sometimes (SOMEtimes) you can change your sheet so that the secondary source is primary. Depends on your data, your usage, etc. I have managed to do this a few times, but most times I need the primary to be primary. In those cases, I need to re-shape data.
