Forum Discussion
Matrix - Measure Row Total
Hello,
I'd like to subtract the difference between two rows within a matrix visual. In the case below, I want to subtract Gross Potential Rent and Rent to determine rent loss.
Is there also a way to subtract the total from two different visuals?
Thank you,
Sharlene
Hi sec12tst8r84,
If [Gross Potential Rent] and [Rent] are two measures, then you should be able to use the formula below to create a new measure to calculate the rent loss, and then show it on the matrix or other visuals. :smileyhappy:
Measure = [Gross Potential Rent] - [Rent]
Regards
1 Reply
Hi sec12tst8r84,
If [Gross Potential Rent] and [Rent] are two measures, then you should be able to use the formula below to create a new measure to calculate the rent loss, and then show it on the matrix or other visuals. :smileyhappy:
Measure = [Gross Potential Rent] - [Rent]
Regards